pg_restore - Mailing list pgsql-sql

From Jyoti Seth
Subject pg_restore
Date
Msg-id 003101c9e8e5$2a31ee80$7e95cb80$@com
Whole thread Raw
List pgsql-sql

Hi all,

 

 I have two databases db1 and db2 with no network connection. I want to take backup of few master tables from db1 and restore it to db2 at frequent intervals.. I do not want to delete data from the tables and restores the fresh data as this data is getting referenced in other tables. I can do that by creating scripts on db1 and executing the same on db2. But I want to know if  I can use pg_restore command to overwrite existing data of these master tables

 

Thanks,

Jyoti

 

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Xml Schemas
Next
From: "Jyoti Seth"
Date:
Subject: backup