Re: INSERT or COPY: Which one?

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