ow writes:
> --- Peter Eisentraut <peter_e@gmx.net> wrote:
> > If you you pg_dump and dump schema and data together, then there is some
> > magic to temporarily disable foreign key constraints. Try it out.
>
> Dunno. Don't see any magic so far. In fact, pg_restore appears to use
> internally the same SQL to verify that the validity of the FKs as "ALTER TABLE
> xxx ADD CONSTRAINT". And it's not any faster either.
Read again. No one was talking of pg_restore.
--
Peter Eisentraut peter_e@gmx.net
