| From: | "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl> |
|---|---|
| To: | Gunther Schadow <gunther(at)aurora(dot)regenstrief(dot)org> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Escaping in COPY |
| Date: | 2002-06-05 23:01:40 |
| Message-ID: | 20020606010140.E75860@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nookala Satish Kumar | 2002-06-06 06:40:00 | I have implemented the CallableStatement for JDBC Driver |
| Previous Message | Gunther Schadow | 2002-06-05 21:54:58 | Re: Escaping in COPY |