Skip site navigation (1) Skip section navigation (2)

restoring a .dmp file to another table name

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 (view raw or flat)
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

Responses

pgsql-general by date

Next:From: Tino WildenhainDate: 2004-08-23 06:43:53
Subject: Re: restoring a .dmp file to another table name
Previous:From: Marc G. FournierDate: 2004-08-23 03:58:05
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group