For most rdbms you would use ALTER TABLE, for postgresql you can't. Lets say you originally created CREATE TABLE example ( col1 varchar, col2 varchar, colthree numeric); then realized colthree was in the wrong table. you can: CREATE TABLE temp AS SELECT col1,col2 FROM example; DROP TABLE EXAMPLE; finally, CREATE TABLE example AS SELECT * FROM temp; hth and good luck Nafiseh Saberi <[EMAIL PROTECTED]> wrote in message 002201c195d6$f07ae390$[EMAIL PROTECTED]">news:002201c195d6$f07ae390$[EMAIL PROTECTED]... > hi dear team... > > how can i delete only one column in one table > with sql in postgres ?? > > thx. > ________________________________ > Sincerely yours Nafiseh Saberi > > People will forget what you said ... > People will forget what you did... > But people will Never Forget > how you made them feel. > > < Any suggestion are welcome to me > > __________________________________ > >
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
