How to get some table entries from backup instance back to production instance

Поиск
Список
Период
Сортировка
От Marcel Ruff
Тема How to get some table entries from backup instance back to production instance
Дата
Msg-id 54D9C3BD.3060003@marcelruff.info
обсуждение исходный текст
Ответы Re: How to get some table entries from backup instance back to production instance  (Martin Steer <martinsteer@maxi.net.au>)
Re: How to get some table entries from backup instance back to production instance  (daku.sandor@gmail.com)
Список pgsql-novice
Дерево обсуждения
Hi,

I have 4 tables with 1:n relation:

 grandpa -> pa -> child -> grandchild

Now I need to copy an instance of "pa" with his descendants
from my backup (a postgres dump) back to prod.
"grandchild" has a blob column (containing fotos)

Which options do I have?

1) Import the backup dump in a separate postgres instance
2) Do some magic query which created insert statements
3) Run the insert statements on the prod server

What is the best approach, and how does a query look like which
returns nicely formatted insert lines?

Thank you
Marcel

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

Предыдущее
От: Lukasz Brodziak
Дата:
Сообщение: Re: Pivot table without crosstab
Следующее
От: Florian Schaetz
Дата:
Сообщение: Problem: Temporary tables not really temporary tables