Re: restore - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: restore
Date
Msg-id 4CAB24F40200002500036550@gw.wicourts.gov
Whole thread Raw
In response to restore  (Dinesh Bhandary <dbhandary@iii.com>)
Responses Re: restore
List pgsql-admin
Dinesh Bhandary <dbhandary@iii.com> 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

pgsql-admin by date:

Previous
From: Dinesh Bhandary
Date:
Subject: restore
Next
From: Scott Whitney
Date:
Subject: Re: restore