Re: [SQL] Slow Inserts Again

Поиск
Список
Период
Сортировка
От Frank Morton
Тема Re: [SQL] Slow Inserts Again
Дата
Msg-id 06da01be956e$a58ee860$8355e5ce@base2inc.com
обсуждение исходный текст
Ответы Re: [SQL] Slow Inserts Again  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список 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?






В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Index on date_trunc
Следующее
От: pierre@desertmoon.com
Дата:
Сообщение: Re: [SQL] Slow Inserts Again