Thread

Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?

Herouth Maoz <herouth@oumail.openu.ac.il> — 1999-10-27T17:21:03Z

At 17:08 +0200 on 22/10/1999, Tom Lane wrote:


> In the meantime, the conventional wisdom is still that you should use
> COPY, if possible, for bulk data loading.  (If you need default values
> inserted in some columns then this won't do...)

Yes it would - in two steps. COPY to a temp table that only has the
non-default columns. Then INSERT ... SELECT ... from that temp table to
your "real" table.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma