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