if you cannot ALTER TABLE, I find it quicker to do it as below (using Dave's example...):
SELECT col1,col2 into tempTable from exampleTable This leaves off col3 data and retains formatting information for other columns, then you can do this: DROP exampleTable SELECT * into exampleTable from tempTable This builds back your original Table. -----Original Message----- From: Dave K [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 1:16 PM To: [EMAIL PROTECTED] Subject: Re: delete one column in table 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] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
