Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Restoring tables with circular references dumped to separate files - Mailing list pgsql-general

From doganmeh
Subject [GENERAL] Restoring tables with circular references dumped to separate files
Date
Msg-id 1508555727791-0.post@n3.nabble.com
Whole thread Raw
Responses Re: [GENERAL] Restoring tables with circular references dumped to separate files
List pgsql-general
Tree view 
I was dumping each table to a separate file so I could pick and choose when
restoring. However, seems this was not a great idea, since two of my tables
happened to reference each other via FOREIGN KEYs, and I am not able to
restore them. Is there a way to do this without manually merging the dump
files? Thanks for guidance in advance. 



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Weird performance difference
Next
From: Uwe
Date:
Subject: Re: [GENERAL] Restoring tables with circular references dumped to separate files