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"