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: (view raw, whole thread or download thread mbox)
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?




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-2017 The PostgreSQL Global Development Group