Thread: Delete column

Delete column

From

Setyo Nugroho

Date:

12 November 2002, 07:51:03

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

Re: Delete column

From

"Henshall, Stuart - Design & Print"

Date:

12 November 2002, 08:00:11

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