Re: Escaping in COPY

On Wed, Jun 05, 2002 at 04:54:58PM -0500, Gunther Schadow wrote:
> 
> I'd be interested too. From the manual I gather that it is extremely
> simple. Only the field delimiter and the row delimiter (alias newline)
> and the escape character itself needs escaping. I have just finished
> uploading a 15 GB medical record database from Oracle and it actually
> worked. I am also very pleased with PostgreSQL's performance so far.
> Ah, this is getting good! I can pump data in at basically the same
> rate that I read it from Oracle. That is, 600 to 2000 records per
> second, and it is with all indexes and foreign keys turned on (FKs
> are initially deferred, but eventually they are checked.)

Ah.  Perhaps I'd better do some more optimization work on COPY support
in libpqxx then.  :-)


Jeroen