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

From Jasen Betts
Subject Re: Restore 1 Table from pg_dumpall?
Date
Msg-id ke2rr3$opo$1@gonzo.reversiblemaps.ath.cx
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?  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 2013-01-22, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>    I neglected to dump a single table before adding additional rows to it via
> psql. Naturally, I messed up the table. I have a full pg_dumpall of all
> three databases and all their tables in a single .sql file from 2 days ago.
> The file is 386M in size and emacs is taking a very long time to move around
> in it.

yeah, emacs is slow on large files.

for a one-off I'd use less(1), to extract the desired table data.

If I had to repeat it i'd use sed or awk

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Cast double precision to integer & check for overflow
Next
From: Jasen Betts
Date:
Subject: Re: Running update in chunks?