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