How to fully restore a single table from a custom dump?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема How to fully restore a single table from a custom dump?
Дата
Msg-id e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net
обсуждение исходный текст
Ответы Re: How to fully restore a single table from a custom dump?
Список pgsql-admin
Hello,

I just realized that using

   pg_restore -t some_table ... some_dump_file

doesn't restore things like identity attributes
or indexes on the specified table.

The dump contains much more than just that table, so simply
using pg_restore without -t is not an option.

While I could extract the indexes manually using some clever regex
on the index names, I don't see a way to make sure that identity
definitions (or sequence values) are restored properly for the selected table.

Any ideas, how I can _fully_ restore a single table from a custom dump?

Thomas



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

Предыдущее
От: manoj kathar
Дата:
Сообщение: Re: error : missing chunk number 3 for toast value 14146136 in pg_toast_8895383
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: How to fully restore a single table from a custom dump?