Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: question about pg_dump -a
- From: Vivek Khera <vivek(at)khera(dot)org>
- To: Postgres General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: question about pg_dump -a
- Date: Fri, 28 Sep 2007 10:30:50 -0400
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.
- Follow-Ups:
- Re: question about pg_dump -a
- From: Ottavio Campana
- Re: question about pg_dump -a
- References:
- question about pg_dump -a
- From: Ottavio Campana
- Re: question about pg_dump -a
- From: Richard Huxton
- Re: question about pg_dump -a
- From: Ottavio Campana
- question about pg_dump -a
- Prev by Date: Re: Debian problem...
- Next by Date: Re: access privileges: grant select on (all current and future tables)?
- Previous by thread: Request for feature: pg_dump schema masquerade flag
- Next by thread: Re: question about pg_dump -a
- Indexes: