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
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