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 simple ascii file and readable
2. using some edit tool to open file anyname.dump and remove the columns you don't want and change the table name as a new one like "table_new" and do:
3. cat anyname.dump | psql your_dbname
4. psql your_db_name
psql> insert into table_new select field1, field2, ... from ori_table;
psql> drop ori_table;
psql> alter table rename table_new ori_table;
Then it is done.
PS. for safe, dump your entire database first
Banghe
Jodi Kanter wrote:
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?ThanksJodi
