Hello List! We're working on restructuring some of our tables in our databases (removing, renaming, &/or adding columns to tables), & adding tables to the database, etc. - and we have a database FULL of info that we want to restore this database with once the updates are done; however, I know that I cannot simply do a 'Restore' to my database if I'm removing/renaming columns, etc since some of the column names that existed in the database that we did the Backup on will not exist in the one that we attempt to do the Restore on... What is the most efficient way to copy/restore data from my old database into my new one taking these changes into consideration? (pgAdmin sure does spoil us, doesn't it?! ;)) We're running Postgres version 8.0.8. Thanks in advance for your time and help with this!! -Jeanna
