Skip site navigation (1) Skip section navigation (2)

Re: [SPAM] Restore single table from pg_dumpall.

From: "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com>
To: "Jim Stalewski" <JStalewski(at)VisaLighting(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [SPAM] Restore single table from pg_dumpall.
Date: 2007-01-23 11:13:56
Message-ID: MBEPKEEDMKGCDODFKLPPGEHDDLAA.duncan.garland@ntlworld.com (view raw or flat)
Thread:
Lists: pgsql-novice
Restore single table from pg_dumpall.Hi,

pg_restore can restore a single table provided that the appropriate switch
was used when creating the dump with pg_dumpall.

If the dump is in plain text then you need to strip out the surplus data and
feed the rest to psql. If the file is too big for vi, try a stream editor
such as sed or a simple perl script.

Regards

Duncan
  -----Original Message-----
  From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Jim Stalewski
  Sent: 22 January 2007 23:06
  To: pgsql-novice(at)postgresql(dot)org
  Subject: [SPAM] [NOVICE] Restore single table from pg_dumpall.


  Greetings,

  I have been asked by a programmer to restore a single table from a
PG_DUMPALL backup.

  Is this possible, and if so, would anyone be able to tell me please, what
PSQL options and switches are required?  Running PostgreSQL 8.1.3.

  Thanks in advance,

  Jim.




  This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender and delete
it. Please note that any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. No employee or agent is authorized to conclude any binding
agreement on behalf of Visa Lighting with another party by email without
express written confirmation by an authorized representative of the Company.
Finally, the recipient should check this email and any attachments for the
presence of viruses. The company accepts no liability for any damage caused
by any virus transmitted by this email.

In response to

Responses

pgsql-novice by date

Next:From: brian stapelDate: 2007-01-23 16:51:51
Subject: Problems w/ Temp Tables
Previous:From: Alan HodgsonDate: 2007-01-22 23:53:08
Subject: Re: Restore single table from pg_dumpall.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group