Re: pg_dump data and foreign keys - Mailing list pgsql-general

From Dennis Gearon
Subject Re: pg_dump data and foreign keys
Date
Msg-id 3E85C5A7.7BED885C@cvc.net
Whole thread Raw
In response to pg_dump data and foreign keys  (John Smith <john_smith_45678@yahoo.com>)
List 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!


pgsql-general by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Select aliasses in where and other places of the selectlist?
Next
From: RobertD.Stewart@mail.state.ky.us
Date:
Subject: functions and triggers