From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Getting tables from one DB to another |
Date: | 2010-12-14 23:07:33 |
Message-ID: | AANLkTikd5ZZSow-LtHc0H6nXdAPjKkeXMpNDBkxb+z9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
We actually have an application with its database working and we are
developing a new version of such an application based on the same database
but with minor changes in a few tables. When finished, we want to get the
data in the actual DB to the new one but we see a liitle problem. Each table
has a serial field which works as a primary key and we would like to keep
these fields with their original values in the new tables. I suppose I
cannot use pg_restore from a backup because of the difference among some old
tables and some new ones; maybe one way could be to write an application
that reads each record from the old table and inserts it to the new one but
in this case the serial field could be different from the original. How can
I achieve this goal?
Respectfully,
Jorge Maldonado
From | Date | Subject | |
---|---|---|---|
Next Message | Trupti Ghate | 2010-12-15 06:41:47 | Need static version of libpq library |
Previous Message | Kenneth Marshall | 2010-12-14 21:45:17 | Re: Datatype for MySQL Varbinary |