Deleting columns, only different

[stick_figure]

Has anyone had to deal with deleting columns when you have an auto-increment column? Let me explain.

I know that deleting columns is an issue that's been addressed here before, but I tried the suggestions, and it screwed up my id field. If I remember correctly, I selected out the columns I wanted, killed the table, and dropped the temporary table back into place over the old one with only the columns I had selected out. That killed the special field properties, like auto-increment and default values etc. I'm using PostgreSQL 7.1. Help? Please?

[leatherback]

Hi,

How about this:

You write a sql statement for each row/colum you want to keep. Export this to a server file. Delect the table, and run each lin ein the created file. THre you can specifify columtypes too.

J.