From: Bryan Sayer <brysayer@gmail.com>
Content-Type: multipart/alternative;
 boundary="------------yyLsQThhRXh0xt0FP0YKvOQV"
Message-ID: <80c44b4d-1185-478b-939c-62e0d4377106@gmail.com>
Date: Thu, 25 Sep 2025 14:49:59 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Language: en-US
Subject: Additional options for COPY from
Archived-At: <https://www.postgresql.org/message-id/80c44b4d-1185-478b-939c-62e0d4377106%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------yyLsQThhRXh0xt0FP0YKvOQV
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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*/
--------------yyLsQThhRXh0xt0FP0YKvOQV
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>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.</p>
    <p>Is there someone or a party that deals with the details of the
      COPY command that I could discuss this with?</p>
    <p>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.</p>
    <div class="moz-signature">-- <br>
      <b>Bryan Sayer</b><br>
      Retired Demographer/Statistician<br>
      <i>In a world in which you can be anything, <b>be kind</b></i>
      <br>
    </div>
  </body>
</html>

--------------yyLsQThhRXh0xt0FP0YKvOQV--