drop column

[Ashok Chauhan]

hello

i have a problem to drop a column.

on postgresql site (link)
http://www.postgresql.org/docs/current/interactive/ddl-alter.html#AEN2124

A command for remove the column but it not work
it gives parse error
ALTER TABLE tablename DROP COLUMN fieldname;

plz. help me

Ashok

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[A.Bhuvaneswaran]

Post by Ashok Chauhan
A command for remove the column but it not work
it gives parse error
ALTER TABLE tablename DROP COLUMN fieldname;

drop column feature is implemented since 7.3. So, you please check out
your version.

regards,
bhuvaneswaran

[Ashok Chauhan]

Post by A.Bhuvaneswaran

Post by Ashok Chauhan
A command for remove the column but it not work
it gives parse error
ALTER TABLE tablename DROP COLUMN fieldname;

drop column feature is implemented since 7.3. So, you please check out
your version.
regards,
bhuvaneswaran

hello

thanks for reply.

yes i am using 7.2 version.
so any other option except drop the table and re-create it.
Ashok


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster