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
>