Home > mailing lists

INSERT or COPY: Which one? - Mailing list pgsql-novice

From	Colin Gillespie
Subject	INSERT or COPY: Which one?
Date	February 17, 2004 17:55:42
Msg-id	52D580A5DC1FC04CB260E80074CFBA5C02036DC3@bond.ncl.ac.uk Whole thread Raw
Responses	Re: INSERT or COPY: Which one? Re: INSERT or COPY: Which one?
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Dexter Tad-y
Date: 17 February 2004, 17:55:38
Subject: is_locked() function for select-for-update locked rows

From:
Date: 17 February 2004, 17:56:31
Subject: Re: Createdb fails

INSERT or COPY: Which one? - Mailing list pgsql-novice

Previous

Next