Re: restore

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <dbhandary(at)iii(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: restore
Date: 2010-10-05 18:15:32
Message-ID: 4CAB24F40200002500036550@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dinesh Bhandary <dbhandary(at)iii(dot)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

In response to

  • restore at 2010-10-05 18:08:11 from Dinesh Bhandary

Responses

  • Re: restore at 2010-10-05 18:32:29 from Dinesh Bhandary

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2010-10-05 18:19:28 Re: restore
Previous Message Dinesh Bhandary 2010-10-05 18:08:11 restore