Re: pg_dump data and foreign keys

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: pg_dump data and foreign keys
Дата
Msg-id 3E85C5A7.7BED885C@cvc.net
обсуждение исходный текст
Ответ на pg_dump data and foreign keys  (John Smith <john_smith_45678@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Select aliasses in where and other places of the selectlist?
Следующее
От: RobertD.Stewart@mail.state.ky.us
Дата:
Сообщение: functions and triggers