Restore After Changing Table Structures

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Restore After Changing Table Structures
Date: 2007-02-23 20:41:15
Message-ID: FBEGJLLJBCOMCDBJHIMEEECGCGAA.jgeier@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2007-02-23 20:49:09 Re: Priorities for users or queries?
Previous Message Dave Page 2007-02-23 20:31:26 Re: Ruby on Rails for PostgreSQL