Re: pg_dump data and foreign keys

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: John Smith <john_smith_45678(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump data and foreign keys
Date: 2003-03-29 16:11:19
Message-ID: 3E85C5A7.7BED885C@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

unfortunately, no. You are best served by dumping the tables manually,
one a at atime, and concatenating them in the order that they need to
be.

Of course, making a script do this means you only have to figure this
out once.

John Smith wrote:
>
> Is data dumped from pg_dump -a supposed to be in order so it doesn't
> cause foreign key conflicts? I'm getting dumps where tables that rely
> on records in other tables are appearing before them.
>
> John
>
> ----------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message RobertD.Stewart 2003-03-29 16:27:34 functions and triggers
Previous Message Arjen van der Meijden 2003-03-29 16:04:51 Select aliasses in where and other places of the selectlist?