Re: [Proposal] Adding TRIM_SPACE option to COPY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Proposal] Adding TRIM_SPACE option to COPY
Date
Msg-id 1132608.1764047815@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Proposal] Adding TRIM_SPACE option to COPY  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: [Proposal] Adding TRIM_SPACE option to COPY
List 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 by date:

Previous
From: Myles Lewis
Date:
Subject: [PATCH] Add native PIVOT syntax for SQL Server/Oracle compatibility
Next
From: Bertrand Drouvot
Date:
Subject: Re: Remove useless casting to the same type