| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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")
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klint Gore | 2004-06-29 23:45:01 | Re: Query using kylix (delphi) |
| Previous Message | Dann Corbit | 2004-06-29 23:31:27 | Re: Postgres tuning? |