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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
