Additional options for COPY from

From: Bryan Sayer <brysayer(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Additional options for COPY from
Date: 2025-09-25 18:49:59
Message-ID: 80c44b4d-1185-478b-939c-62e0d4377106@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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*/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-09-25 19:10:46 Re: Enquiry about Percona TDE performance issues
Previous Message Roberto Gallesio 2025-09-25 15:38:42 Compatibility Informations