Restore 1 Table from pg_dumpall?

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Restore 1 Table from pg_dumpall?
Дата
Msg-id alpine.LNX.2.00.1301220953340.12700@salmo.appl-ecosys.com
обсуждение исходный текст
Ответы Re: Restore 1 Table from pg_dumpall? [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: Restore 1 Table from pg_dumpall?  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Restore 1 Table from pg_dumpall?  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Список pgsql-general
Дерево обсуждения 
   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.

   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.

Rich

В списке pgsql-general по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Yet Another Timestamp Question: Time Defaults
Следующее
От: Edson Richter
Дата:
Сообщение: What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?