Awesome, this will work. It won't retain the column name in insert
into statement. I was not sure if this will work with postgres 8.2.5 but
it does.
Thanks.
Dinesh
On 10/5/2010 11:15 AM, Kevin Grittner wrote:
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