Re: csv format for psql
Fabien COELHO <coelho@cri.ensmp.fr>
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: pgsql-hackers@postgresql.org
Date: 2018-03-10T06:49:45Z
Lists: pgsql-hackers
>> recordsep in the unaligned mode doesn't play the role of a line ending >> because the last line is not finished by recordsep. According to the source >> code, this is intended, see print_unaligned_text() in print.c: > > Something else comes to mind: CSV allows linefeeds inside fields, and > we don't want to replace these with record separators. Sure. > So the notion that recordsep can be used to choose line endings > is even less okay than if there was just the last line issue. I'm not following. ISTM that the escaping macanism would work in pretty all reasonable cases, although it might be possible to shot oneself in the foot by setting manually strange values for recordsep, eg '"'. I do not see that as a significant issue. If the user asks for something stupid, they get something stupid, fine. -- Fabien.
Commits
-
Add CSV table output mode in psql.
- aa2ba50c2c13 12.0 landed
-
Reorganize format options of psql in alphabetical order
- add9182e5908 12.0 landed
-
Complete TODO item:
- 862b20b38228 8.0.0 cited