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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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