How to drop column ?
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
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
How to drop column ?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 -----
From: Vitali Djatsuk
To: pgsql-general@postgresql.org
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"