> Can we see on line of the csv output? The field with commas should be in > quotes, no? You’ll have write a “real” csv importer. awk =F”\”*,*\”” > might, heavy on the might.
Rob,
Here's a redacted output line:
8,2019-04-08,Phone,Went to voice mail @ 14:48; didn't leave a message. Call Wednesday morning,8,<lname>,<fname>,537,537,<company_name>
No quoted text fields.
text fields are quoted only when it is necessary
[pavel@localhost src]$ psql -c "select 'ahoj' as x, 'svete' as y" --csv Assertions: on x,y ahoj,svete [pavel@localhost src]$ psql -c "select 'ahoj' as x, 'sve,te' as y" --csv Assertions: on x,y ahoj,"sve,te"
If you need forced quoting, you need to use COPY TO STDOUT statement
[pavel@localhost src]$ psql -c "copy (select 'ahoj' as x, 'svete' as y) to stdout force quote * csv header" Assertions: on x,y "ahoj","svete"
