Re: [GENERAL] Efficiently move data from one table to another, with FK constraints?

2009-07-07 Thread Albe Laurenz
Rob W wrote: > I am using COPY to bulk load large volumes (i.e. multi GB > range) of data to a staging table in a PostgreSQL 8.3. For > performance, the staging table has no constraints, no primary > key, etc. I want to move that data into the "real" tables, > but need some advice on how to do

[GENERAL] Efficiently move data from one table to another, with FK constraints?

2009-07-06 Thread Rob W
I am using COPY to bulk load large volumes (i.e. multi GB range) of data to a staging table in a PostgreSQL 8.3. For performance, the staging table has no constraints, no primary key, etc. I want to move that data into the "real" tables, but need some advice on how to do that efficiently. Here