| From: | "Frank Morton" <fmorton(at)base2inc(dot)com> |
|---|---|
| To: | <pgsql-sql(at)hub(dot)org>, "Herouth Maoz" <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
| Subject: | Re: [SQL] Slow Inserts Again |
| Date: | 1999-05-03 14:10:06 |
| Message-ID: | 06da01be956e$a58ee860$8355e5ce@base2inc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
>> I have tried many combinations of things to speed this
>> up as you all have suggested. I have had no success
>> using "copy" at all because of problems with quotes
>> and other punctuation in the data.
>
>I must tell you, this doesn't sound reasonable to me. It's usually very
>easy, if you already have a program that writes down the fields, to make
>sure it scans the contents thereof and adds a backslash before each tab,
>newline and backslash in every one of the fields.
Is there a doc somewhere about what characters are treated
in some special way when doing a copy?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1999-05-03 14:27:25 | Re: [SQL] Slow Inserts Again |
| Previous Message | Tatsuo Ishii | 1999-05-03 14:08:54 | Re: [HACKERS] Re: SIGBUS in AllocSetAlloc & jdbc |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Bitmead | 1999-05-03 14:16:53 | Re: [SQL] No DIVIDE Operator |
| Previous Message | pierre | 1999-05-03 14:06:53 | Re: [SQL] Slow Inserts Again |