Re: [GENERAL] COPY with default values won't work?

From: Oleg Broytmann <phd(at)sun(dot)med(dot)ru>
To: Charles Tassell <ctassell(at)isn(dot)net>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] COPY with default values won't work?
Date: 1999-03-24 09:23:24
Message-ID: Pine.SOL2.3.96.SK.990324122233.21128A-100000@sun.med.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Broytmann 1999-03-24 09:25:16 Re: [GENERAL] COPY with default values won't work?
Previous Message K.T. 1999-03-24 08:05:46 Re: [GENERAL] COPY with default values won't work?