Re: Building a database from a flat file - Mailing list pgsql-sql

On Thu, 2005-03-03 at 06:23 -0700, Sean Davis wrote:
> Why not rebuild the entire thing in a separate "build" schema then do
> only the stuff like copying tables inside the transaction block:
> 

Building everything in the separate "build" schema works great, but it
is the DELETE (TRUNCATE won't work when foreign keys point to the table)
that took the most time in the transaction.  However, renaming the
schemas, as suggested in other posts, worked great.

Casey