Re: Restore 1 Table from pg_dumpall? [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore 1 Table from pg_dumpall? [RESOLVED]
Date: 2013-01-22 18:07:44
Message-ID: alpine.LNX.2.00.1301221006190.12700@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2013-01-22 18:17:06 Re: Restore 1 Table from pg_dumpall? [RESOLVED]
Previous Message Edson Richter 2013-01-22 17:57:46 What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?