On 2013-01-22, Rich Shepard <rshep...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
