Обсуждение: Delete column

Поиск
Список
Период
Сортировка

Delete column

От
Setyo Nugroho
Дата:
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

От
"Henshall, Stuart - Design & Print"
Дата:

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