Re: recreating table and foreign keys - Mailing list pgsql-sql

> You'll probably end up using ALTER TABLE ADD CONSTRAINT to add the
> constraints to the new master_table.  It's possible that you might 
> be able to hack something with the system tables, but that sounds 
> dangerous.  Or you can upgrade to 7.3 which lets you run alter table 
> drop column. :)
If it is the only way, I can create >20 "alter table add constraint...", but 
is rather a boring finish :-(
I found, I can dump database - data only. After this I can create all tables 
and restore data.

Any other solution?
Tomasz Myrta