Re: What Would You Like To Do?

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
> >         table
> >         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
table?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +