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

Hi,

I would do this way: 

After the first step select the required records into another tables with CREATE TABLE patmp AS SELECT * FROM pa WHERE ...

Move these temporary tables to the prod database by dump and restore and transfer the content into the prod tables with INSERT INTO pa SELECT * FROM patmp.

Done.

Regards,

Sándor Daku

On 10 Feb 2015, at 09:39, Marcel Ruff <mr@marcelruff.info> wrote:

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