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. +