beginners postgres question

graham graham at theseamans.net
Mon Oct 8 12:06:34 BST 2007


Andreas Plesner Jacobsen wrote:
> On Mon, Oct 08, 2007 at 11:25:08AM +0100, graham wrote:
>> At this point I discover that pg_dump produces dump files which cannot 
>> be reloaded, since they take no account of dependencies. For example, I 
>> have a lot of join tables, which necessarily depend on foreign keys from 
>> other tables. But pg_dump produces output with these tables BEFORE the 
>> ones the keys come from.
> 
> pg_dump dumps the constraints at the end, so this shouldn't be a
> problem.
> 

I'm using

	pg_dump --data-only

so I can load my schema from one source, and my data from the dump file. 
  There are no constraints in the dump file I create, they are in the 
running database


Graham


More information about the london.pm mailing list