Re: Emitting JSON to file using COPY TO - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id 5c84b70b-ba18-c45d-dbbe-612fa229b2ce@dunslane.net
Whole thread Raw
In response to Re: Emitting JSON to file using COPY TO  (Davin Shearer <davin@apache.org>)
Responses Re: Emitting JSON to file using COPY TO
List pgsql-hackers


On 2023-12-04 Mo 13:37, Davin Shearer wrote:
Looking great!

For testing, in addition to the quotes, include DOS and Unix EOL, \ and /, Byte Order Markers, and mulitbyte characters like UTF-8.

Essentially anything considered textural is fair game to be a value.


Joe already asked you to avoid top-posting on PostgreSQL lists. See <http://idallen.com/topposting.html> for an explanation.

We don't process BOMs elsewhere, and probably should not here either. They are in fact neither required nor recommended for use with UTF8 data, AIUI. See a recent discussion on this list on that topic: <https://www.postgresql.org/message-id/flat/81ca2b25-6b3a-499a-9a09-2dd21253c2cb%40unitrunker.net>


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: "Tristan Partin"
Date:
Subject: Re: meson: Stop using deprecated way getting path of files
Next
From: Laurenz Albe
Date:
Subject: Re: Postgres Partitions Limitations (5.11.2.3)