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

On Tue, Feb 10, 2015 at 09:39:25AM +0100, Marcel Ruff wrote:
>
>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?

You want to copy some tables from one db (or dump) to another?

Perhaps you should look at the man pages for pg_dump and pg_restore.
pg_restore allows the loading of a single table, or group of tables,
into a specified database.

M.