Skip site navigation (1) Skip section navigation (2)

INSERT or COPY: Which one?

From: "Colin Gillespie" <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: INSERT or COPY: Which one?
Date: 2004-02-16 10:13:16
Message-ID: 52D580A5DC1FC04CB260E80074CFBA5C02036DC3@bond.ncl.ac.uk (view raw or flat)
Thread:
Lists: pgsql-novice
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



Responses

pgsql-novice by date

Next:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-02-16 12:50:06
Subject: PostgreSQL From xinit
Previous:From: joseph speigleDate: 2004-02-15 23:56:57
Subject: Re: Changing from NOT NULL to NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group