| From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org (pgsql general list) |
| Subject: | restoring a .dmp file to another table name |
| Date: | 2004-08-23 04:15:38 |
| Message-ID: | 200408230415.i7N4Fdid017809@gw.tssi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've probably asked this question before, but what do people do when they
need to restore a table that has been dumped but as a different table
name? That doesn't appear to be an option in pg_restore. (Is that just
a front end to psql?)
I need both the old table and the live one in the same database so
that I can compare a set of values to see what changed, and I don't have
a spare system to do it on at the moment, nor can I rename the live file
since it is in use most of the day.
This is a fairly large table (2.8M rows, 500MB dump file) and I think
it may have some data in it that would get messed up if I were to try to
extract the DDL leading up to the COPY statement using head and tail
statements to change the table name.
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2004-08-23 06:43:53 | Re: restoring a .dmp file to another table name |
| Previous Message | Marc G. Fournier | 2004-08-23 03:58:05 | Re: Unsupported 3rd-party solutions (Was: Few questions |