On Tue, Feb 10, 2015 at 02:50:16PM +0100, Marcel Ruff wrote:
>On 10.02.2015 13:36, Martin Steer wrote:
>
> 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
>
>No, only some instances of "pa" with its children.
>My end user deleted by mistake some "pa"s and now wants to have
>them back.
>
>If I can use pg_dump / pg_restore with some where condition it would
>be the perfect solution, but after reading the man page (as you suggested)
>it is not possible.
You can use your where condition in db1 to create the export-pa tables.
Then dump them and restore them to db2.
M.