Re: INSERT or COPY: Which one?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Colin Gillespie <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: INSERT or COPY: Which one?
Date: 2004-02-17 20:01:41
Message-ID: 40327325.6050601@e-trolley.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Colin Gillespie wrote:
> Dear All,
>
> I which to insert text (more than 1000 lines) into a single cell of my table, should I use COPY here or INSERT?
>
> My reading seems to suggest that you would use COPY for mulitple INSERTs, but when inserting alot of data into one cell, INSERT is fine. Is this correct?

COPY is much faster, INSERT is safer.
I heard that all issues regarding COPY are fixed (since 7.3?), but IIRC I still had some trouble
with SERIALs and referential integrity.

HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luc ROLLAND 2004-02-17 20:01:51 Create Rule
Previous Message Bryan Irvine 2004-02-17 19:09:06 Re: Unable to connect to PostgreSQL server: