Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19403: psql fails when trying to import a file that
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: daniel_adeniji@hotmail.com
Reply-To: daniel_adeniji@hotmail.com, pgsql-bugs@lists.postgresql.org
Date: Thu, 12 Feb 2026 12:24:09 +0000
Message-ID: <19403-59b4099e771c1f2e@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19403-59b4099e771c1f2e%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19403
Logged by:          Daniel Adeniji
Email address:      daniel_adeniji@hotmail.com
PostgreSQL version: 17.6
Operating system:   MS Windows 10 ( PostgreSQL 17.6 on x86_64-windows
Description:       =20

Database Table
--------------------
CREATE TABLE public.codeblock
(
        id int4 NULL,
        body text NULL
);

Text File
-----------
Id,Body
1,"{}
\.
"


Command
--------------
psql.exe --host  --command "\copy public.codeblock from
'c:\tmp\codeblock.csv'  WITH (HEADER, FORMAT CSV, ENCODING 'UTF8', DELIMITER
','   )"

Error Message reads:-

ERROR:  unterminated CSV quoted field
CONTEXT:  COPY codeblock, line 4: "1,"{}
\.
"

The same data works when inserted within an insert statement:-

delete

from public.codeblock

where id =3D 1;

insert into public.codeblock
(
    Id,Body
)
values
(

  1
  ,'{}
\.
'
)
;

It also works when the server-side copy statement is used:-

psql.exe --host  --command "copy public.codeblock from
'c:\tmp\codeblock.csv'  WITH (HEADER, FORMAT CSV, ENCODING 'UTF8', DELIMITER
','   )"

In the example above, \copy is replaced with the copy command and file is
availed on the server.

Data file availed at

1) One Compiler

https://onecompiler.com/text/44dbtdb52

2) GitLab

https://gitlab.com/-/snippets/5933548