Dinesh Bhandary <dbhandary@xxxxxxx> wrote: > Is there an easy way to restore to a new table where the column > name have been changed but data remains the same? Restore to the old name and then rename the column? Access the backup file and change the COPY statement to the new column name? If you can redo the dump, you don't mind the load running a little slower, and the column order is the same -- dump with the --inserts switch? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
