Re: ALTER DROP COLUMN

I know it's a pain, but it isn't all that bad.  Just rename your
table like so:

ALTER TABLE <old_name> RENAME TO <another_name>

Then re-create the old table without the deleted column(s):

SELECT col1, col2, col4 INTO TABLE <old_name> FROM
<another_name>

Then delete the old table:

DROP TABLE <another_name>

--- "ross::barna" <rbarna@neochi.com> wrote:
> neochi=> ALTER TABLE news DROP COLUMN date;
> ERROR:  ALTER TABLE/DROP COLUMN not yet implemented
>
>
> What's that about???  How do I drop a field of a table?!
>
> Thanks,
> -Ross
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/