Re: Delete column

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: 'Setyo Nugroho' <snugroho(at)gmx(dot)net>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Delete column
Date: 2002-11-12 09:57:33
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116AAB@WCPEXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message cristi 2002-11-12 10:53:15 Re: SQL
Previous Message Setyo Nugroho 2002-11-12 09:56:58 Delete column