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
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 |