On 9/25/25 11:49, Bryan Sayer wrote:
Hi,
I'm not sure if this is the best list to ask this (and I am very new to
PostgreSQL) but I think more options are needed in the COPY from
command, in order to better deal with exceptions. By exceptions I mean
data not consistent with the format, empty r
On Thursday, September 25, 2025, Bryan Sayer wrote:
> Is there someone or a party that deals with the details of the COPY
> command that I could discuss this with?
>
This mailing list is the primary medium that reaches a large number of
people some of whom may wish to join in your discussion. J
As I understand it, COPY is intended as a simple & fast way to get clean data
into Postgres.
It is not intended to groom data during the process. There are a variety of ETL
tools that can apply filters & rules to data streams to do what you are asking,
so no need to invent another Postgres speci
On Thu, Sep 25, 2025 at 3:49 PM Bryan Sayer wrote:
> Hi,
>
> I'm not sure if this is the best list to ask this (and I am very new to
> PostgreSQL) but I think more options are needed in the COPY from command,
> in order to better deal with exceptions. By exceptions I mean data not
> consistent wi
Hi,
I'm not sure if this is the best list to ask this (and I am very new to
PostgreSQL) but I think more options are needed in the COPY from
command, in order to better deal with exceptions. By exceptions I mean
data not consistent with the format, empty rows, extra delimiters at the
end of r
