On 09/24/2011 09:51 AM, Bruce Momjian wrote:
Joshua D. Drake wrote:
On 09/13/2011 11:51 AM, Michael Nolan wrote:

         The ability to restore a table from a backup file to a different
         name in the same database and schema.

     This can be done but agreed it is not intuitive.

Can you elaborate on tha a bit, please?  The only way I've been able to
do it is to edit the dump file to change the table name.  That's not
very practical with a several gigabyte dump file, even less so with one
that is much larger.  If this capability already exists, is it documented?
You use the -Fc method, extract the TOC and edit just the TOC (so you
don't have to edit a multi-gig file)
How does that work in practice?  You dump the TOC, edit it, restore the
TOC schema definition, then how do you restore the data to the renamed

How do you extract the TOC at all? There are no tools for manipulating the TOC that I know of, and I'm not sure we should provide any. It's not documented, it's a purely internal artefact. The closest thing we have to being able to manipulate it is --list/--use-list, and those are useless for this purpose. So this method description does not compute for me either.

+1 for providing a way to restore an object to a different object name.



Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to