Re: Restore 1 Table from pg_dumpall?

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