Re: question about pg_dump -a - Mailing list pgsql-general

From Vivek Khera
Subject Re: question about pg_dump -a
Date
Msg-id 8F8AB379-0E8A-406F-B023-63B28FA0AD3C@khera.org
Whole thread Raw
In response to Re: question about pg_dump -a  (Ottavio Campana <ottavio@campana.vi.it>)
Responses Re: question about pg_dump -a  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
On Sep 28, 2007, at 9:07 AM, Ottavio Campana wrote:

> But why does pg_dump does not already exports data such that previous
> tables do not depend on successive ones?

Because you can't always sort your tables that way.  The restore
procedure is responsible for either sorting or disabling the FK
checks during bulk load.  The latter is more efficient, especially if
there are no indexes yet, as in a full restore from dump.

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Debian problem...
Next
From: "John D. Burger"
Date:
Subject: Re: access privileges: grant select on (all current and future tables)?