Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore 1 Table from pg_dumpall? [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Restore 1 Table from pg_dumpall? [RESOLVED]
Date
Msg-id alpine.LNX.2.00.1301221006190.12700@salmo.appl-ecosys.com
Whole thread Raw
In response to Restore 1 Table from pg_dumpall?  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Restore 1 Table from pg_dumpall? [RESOLVED]  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
On Tue, 22 Jan 2013, Rich Shepard wrote:

>  Is there a way I can extract a single table's schema and data from the
> full backup? If so, I can then drop the fubar'd table and do it correctly
> this time.

   My solution: view the file in the pager I use (less), then copy relevant
lines to another file opened in a text editor (joe).

Rich

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Restore 1 Table from pg_dumpall? [RESOLVED]