Home > mailing lists

Re: New COPY options: DELIMITER NONE and QUOTE NONE - Mailing list pgsql-hackers

From	Andrew Dunstan
Subject	Re: New COPY options: DELIMITER NONE and QUOTE NONE
Date	May 19, 2023 20:03:14
Msg-id	fd88c4f8-a6f7-a111-c4e9-80b6a71ff451@dunslane.net Whole thread Raw
In response to	New COPY options: DELIMITER NONE and QUOTE NONE ("Joel Jacobson" <joel@compiler.org>)
Responses	Re: New COPY options: DELIMITER NONE and QUOTE NONE
List	pgsql-hackers

On 2023-05-19 Fr 05:24, Joel Jacobson wrote:

I hacked together a broken patch just to demonstrate the idea on syntax

and basic idea. The `COPY ... FROM` examples above works.

But it doesn't work at all for `COPY ... TO`, since it output \0 byte as

delimiter and quote in the output, which is of course not what we want.

I think you've been a bit too cute with the grammar changes, but as you say this is a POC.

cheers

andrew

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

From: jian he
Date: 19 May 2023, 19:59:35
Subject: Re: PG 16 draft release notes ready

From: Andrew Dunstan
Date: 19 May 2023, 20:08:21
Subject: Re: Adding SHOW CREATE TABLE