Quick Links

Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n'

From:	Chapman Flack <chap(at)anastigmatix(dot)net>
To:	"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Joel Jacobson <joel(at)compiler(dot)org>
Cc:	PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n'
Date:	2021-05-05 17:23:01
Message-ID:	6092D475.8060003@anastigmatix.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

On 05/05/21 13:02, David G. Johnston wrote:
> Why not just allow: "DELIMITER NONE" to be valid syntax meaning exactly
> what it says and does exactly what you desire?

What would it mean? That you get one column, multiple rows of text
corresponding to "lines" delimited by something, or that you get one
column, one row of text for the entire content of the file?

Regards,
-Chap

In response to

Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n' at 2021-05-05 17:02:33 from David G. Johnston

Responses

Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n' at 2021-05-05 17:34:18 from Isaac Morland

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Robert Haas	2021-05-05 17:32:57	Re: MaxOffsetNumber for Table AMs
Previous Message	Jeff Davis	2021-05-05 17:21:58	Re: MaxOffsetNumber for Table AMs