RE: delete one column in table

2002-01-05 Thread McCollum, Frank
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

Re: delete one column in table

2002-01-05 Thread Dave K
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;

delete one column in table

2002-01-05 Thread nafiseh saberi
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. < An

delete one column in table

2002-01-01 Thread nafiseh saberi
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. < An