Re: Delete column - Mailing list pgsql-novice

From Henshall, Stuart - Design & Print
Subject Re: Delete column
Date
Msg-id E382B5D8EDE1D6118DBE0008C759BCD6116AAB@WCPEXCHANGE
Whole thread Raw
In response to Delete column  (Setyo Nugroho <snugroho@gmx.net>)
List pgsql-novice

Setyo Nugroho wrote:
> Hi all,
> I failed to delete a column of a table, using these:
>
> db=# ALTER TABLE route DELETE COLUMN plan;
> db=# ALTER TABLE route DROP COLUMN plan;
>
> Adding a column using ALTER TABLE etc .. is possible, what about
> deleting it ?
>
> Any help would highly be appreciated.
>
> Regards,
> Setyo Nugroho
>
This is possible in pg7.3, but not before
hth,
- Stuart

pgsql-novice by date:

Previous
From: Setyo Nugroho
Date:
Subject: Delete column
Next
From: "cristi"
Date:
Subject: Re: SQL