Re: csv format for psql
David G. Johnston <david.g.johnston@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>,
Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-03-09T20:00:43Z
Lists: pgsql-hackers
On Fri, Mar 9, 2018 at 12:42 PM, Daniel Verite <daniel@manitou-mail.org> wrote: > I wrote: > > > 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. > 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 - if recordsep is not something that would interpreted as a newline then the file we output would have not structural newlines. It might have data newlines but those would be quoted. David J.
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