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
> 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
signature.asc
Description: This is a digitally signed message part
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
--
ement execute successfully. Then drop the old table
and change table name (alter table ... rename to ...).
I am a newbie of postgres.
lonh
- Original Message -
From: Jodi Kanter
To: Postgres Admin List
Sent: Thursday, January 24, 2002 2:54 AM
Subject: [ADMIN] drop column?
I cannot seem
Probably not, but I don't the new version.
There are some ways you can do for this prupose.
Create a new table in that database without that columns. you can do
this very easily:
1. pg_dump -t table_name -s your_dbname > anyname.dump
the switch -s means without data, schem only. it is a
very
>Can I remove this column or will I need to drop the entire table and
restore from backup?
There's not a "remove column" option for alter table, but you may be able to
get around restoring by renaming the existing table, creating a replacement
the way you want it to look, & then copy from the ol
This is something I have been wanting for a long time. The ability to
update or drop a column from a table.
Right now you have to select the columns you want into a temp table and
drop the working table and rename the temp table to the working table.
|On 020123 12:15
|Jodi Kanter ([EMAIL PROTEC
I cannot seem to locate any documentation about removing a column that I
just added to a table. There is no data in that particular column but there is
in the rest of the table.
Can I remove this column or will I need to drop the entire table and
restore from backup?
Thanks
Jodi
___