Re: INSERT or COPY: Which one?

Hi Colin,

COPY is much faster that INSERT, although INSERT is safer. I think that
you can speed up the INSERT by disabling autocommit...


Cheers!
Wim

On Mon, 16 Feb 2004, 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?
>
> Thanks
>
> Colin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match