Horton

Re: csv format for psql

Corey Huinker <corey.huinker@gmail.com>

View thread View on postgr.es
From: Corey Huinker <corey.huinker@gmail.com>
To: tgl@sss.pgh.pa.us
Cc: coelho@cri.ensmp.fr, michael@paquier.xyz, daniel@manitou-mail.org, pgsql-hackers@postgresql.org
Date: 2018-11-26T04:19:11Z
Lists: pgsql-hackers 
>
>
> Or we could kill both issues by hard-wiring the separator as ','.


+1

I've never encountered a situation where a customer wanted a custom
delimiter AND quoted strings. So either they wanted pure CSV or a customed
TSV.

Could we have another output type called "separated" that uses the existing
--fieldsep / --recordsep? Word will get out that csv is faster, but we'd
still have the flexibility if somebody really wanted it.

Commits

  1. Add CSV table output mode in psql.

  2. Reorganize format options of psql in alphabetical order

  3. Complete TODO item: