Re: [Proposal] Adding TRIM_SPACE option to COPY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Proposal] Adding TRIM_SPACE option to COPY
Дата
Msg-id 1132608.1764047815@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Proposal] Adding TRIM_SPACE option to COPY  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: [Proposal] Adding TRIM_SPACE option to COPY
Список pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> On Tue, Nov 25, 2025 at 1:18 AM 河田達也 <kawatatatsuya0913@gmail.com> wrote:
>> I'd like to propose adding a new option, TRIM_SPACE, to the COPY command.

> I like this idea in general.

I'm kind of down on it, because it's inevitably going to add
processing overhead to every COPY operation whether the feature
is used or not.  I don't find it likely to be sufficiently
useful to justify that universal cost.

COPY is not a general-purpose filter or ETL tool, and we try
to make it one at our peril.

            regards, tom lane



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