Re: Restore 1 Table from pg_dumpall?

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Restore 1 Table from pg_dumpall?
Дата
Msg-id ke2rr3$opo$1@gonzo.reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Restore 1 Table from pg_dumpall?  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Restore 1 Table from pg_dumpall?
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Cast double precision to integer & check for overflow
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Running update in chunks?