Re: proposal - support tsv output format for psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal - support tsv output format for psql
Date
Msg-id CAFj8pRDJ2+YGaM6AA9QT=O2ByBWcdqz1Lr5=jnXm49OpECNTEw@mail.gmail.com
Whole thread Raw
In response to Re: proposal - support tsv output format for psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal - support tsv output format for psql  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers


st 23. 12. 2020 v 16:24 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Bruce Momjian <bruce@momjian.us> writes:
> On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
>> Implementation of tsv format should not be hard.
>> What do you think about this?

> How would you handle tabs in the data?

The main problem with csv is the severe lack of standardization
around what to do with corner cases (delimiters in data, empty
fields, etc).  Seems like "tsv" would be even worse.  Is there
an actual standard anywhere?

Probably not - there are just common conventions.

standard disallows tab chars inside


Regards

Pavel


                        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal - support tsv output format for psql
Next
From: Bruce Momjian
Date:
Subject: Re: proposal - support tsv output format for psql