public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bryan Sayer <[email protected]>
To: [email protected] <[email protected]>
Subject: Additional options for COPY from
Date: Thu, 25 Sep 2025 14:49:59 -0400
Message-ID: <[email protected]> (raw)
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 rows, etc.
Is there someone or a party that deals with the details of the COPY
command that I could discuss this with?
Just for context, I am dealing with delimited data of millions of rows
and perhaps 60 columns or so that I wish to read into tables in a
Postgres 17 database under Windows 11, with everything on local drives.
--
*Bryan Sayer*
Retired Demographer/Statistician
/In a world in which you can be anything, *be kind*/
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Additional options for COPY from
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox