Re: [GENERAL] COPY with default values won't work? - Mailing list pgsql-general

From Oleg Broytmann
Subject Re: [GENERAL] COPY with default values won't work?
Date
Msg-id Pine.SOL2.3.96.SK.990324122233.21128A-100000@sun.med.ru
Whole thread Raw
In response to Re: [GENERAL] COPY with default values won't work?  (Charles Tassell <ctassell@isn.net>)
List pgsql-general
Hello!

On Wed, 24 Mar 1999, Charles Tassell wrote:
> My problem is that I might be using this to put a few thousand entries in
> the db every night, and when I last attempted this using a few thousand
> insert statements, it was awfully slow (on the order of taking HOURS)

   DROP INDEX
   BEGIN WORK
   COPY .......
   END
   CREATE INDEX

Oleg.
----
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.


pgsql-general by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [GENERAL] COPY with default values won't work?
Next
From: Oleg Broytmann
Date:
Subject: Re: [GENERAL] COPY with default values won't work?