Skip site navigation (1) Skip section navigation (2)

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

From: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
To: Charles Tassell <ctassell(at)isn(dot)net>
Cc: Vadim Mikheev <vadim(at)krs(dot)ru>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] COPY with default values won't work?
Date: 1999-03-24 12:08:34
Message-ID: Pine.LNX.4.04.9903240707140.17016-100000@dragosani.lan2wan.com (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, 24 Mar 1999, Charles Tassell wrote:

> @#$#!!  Any way to make COPY use default, or shove a lot of data in with a
> single INSERT query?  According to older messages in the mailing list, it
> is *possible*, but I can't get it to work.
> 
> 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)

You could write a perl script to read the data column by column frm the
text file and insert it into the databse using the Pg module.

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Quantum Mechanics is God's version of "Trust me."

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------


In response to

pgsql-general by date

Next:From: Herouth MaozDate: 1999-03-24 13:14:39
Subject: Re: [GENERAL] COPY with default values won't work?
Previous:From: Matthew HixsonDate: 1999-03-24 10:41:48
Subject: PAM module for Postgres?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group