Thread: drop column

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

> 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

On Tue, 2003-12-30 at 14:04, A.Bhuvaneswaran wrote:
> > 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