Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to drop column ?

How to drop column ?

From
"Vitali Djatsuk"
Date:

Hi ALL,

ALTER TABLE palk DELETE COLUMN tempcol;
ERROR:  parser: parse error at or near "DELETE"

Re: How to drop column ?

From
Devrim GUNDUZ
Date:
Hi,

On Sat, 12 Apr 2003, Vitali Djatsuk wrote:

> ALTER TABLE palk DELETE COLUMN tempcol;
> ERROR:  parser: parse error at or near "DELETE"

ALTER TABLE palk DROP COLUMN tempcol;

Regards,
--
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr
            http://www.gunduz.org

Re: How to drop column ?

From
Shridhar Daithankar
Date:
On Saturday 12 April 2003 16:32, you wrote:
> Hi ALL,
>
> ALTER TABLE palk DELETE COLUMN tempcol;
> ERROR:  parser: parse error at or near "DELETE"

That is alter table drop column

 Shridhar

Re: How to drop column ?

From
"Alam Surya"
Date:
you have to write like this :
 
ALTER TABLE palk DROP COLUMN tempcol;
 
to clearly you can see the postgresql manual with : \h alter table
 
best regards
 
Alam Surya   
----- Original Message -----
Sent: Saturday, April 12, 2003 6:02 PM
Subject: [GENERAL] How to drop column ?

Hi ALL,

ALTER TABLE palk DELETE COLUMN tempcol;
ERROR:  parser: parse error at or near "DELETE"