Re: pg_dump and pg_dumpall in real life - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_dump and pg_dumpall in real life
Date
Msg-id 52817328.7040001@dunslane.net
Whole thread Raw
In response to Re: pg_dump and pg_dumpall in real life  (David Johnston <polobo@yahoo.com>)
List pgsql-hackers
On 11/11/2013 05:50 PM, David Johnston wrote:
> Andrew Dunstan wrote
>> A general ability to rename things would be good. In particular,
>> restoring schema x into schema y or table x into table y would be very
>> useful, especially if you need to be able to compare old with new.
> compare old and new what?

Data is what I had in mind.

There have been plenty of times when I've been asked ex post to find out 
what's changed in some table in the last 24 hours or something like 
that, and all I've had to work with is yesterday's dump file. The 
handsprings you have to turn in order to get the old version of the 
table and the new version side by side make it painful - it would be 
nice to be able to say "restore this table but with that name," or 
"restore this table but into that schema".


cheers

andrew



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Fast insertion indexes: why no developments
Next
From: Tom Lane
Date:
Subject: Re: Clang 3.3 Analyzer Results