| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Davin Shearer <davin(at)apache(dot)org>, Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Emitting JSON to file using COPY TO |
| Date: | 2023-12-04 20:06:31 |
| Message-ID: | 5c84b70b-ba18-c45d-dbbe-612fa229b2ce@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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>
<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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2023-12-04 21:40:18 | Re: Help understand why DELETE is so slow |
| Previous Message | Davin Shearer | 2023-12-04 18:37:06 | Re: Emitting JSON to file using COPY TO |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-12-04 20:10:05 | Re: Postgres Partitions Limitations (5.11.2.3) |
| Previous Message | Tristan Partin | 2023-12-04 19:55:17 | Re: meson: Stop using deprecated way getting path of files |