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

Re: Postgres tuning?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: wespvp(at)syntegra(dot)com
Cc: Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk>,Postgres List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres tuning?
Date: 2004-06-29 23:35:16
Message-ID: 20040629233515.GB26189@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Jun 29, 2004 at 06:01:51PM -0500, wespvp(at)syntegra(dot)com wrote:

> The closest thing is COPY.  I've been told COPY does such a bulk load.  The
> down side of COPY is that you have to know the column order - ok for initial
> loads, but dangerous for application usage.

As of 7.3 you can use COPY with a column list.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"You knock on that door or the sun will be shining on places inside you
that the sun doesn't usually shine" (en Death: "The High Cost of Living")


In response to

pgsql-general by date

Next:From: Klint GoreDate: 2004-06-29 23:45:01
Subject: Re: Query using kylix (delphi)
Previous:From: Dann CorbitDate: 2004-06-29 23:31:27
Subject: Re: Postgres tuning?

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