po 19. 7. 2021 v 21:12 odesílatel Pavel Stehule <pavel.steh...@gmail.com> napsal:
> > > po 19. 7. 2021 v 21:07 odesílatel Rich Shepard <rshep...@appl-ecosys.com> > napsal: > >> On Mon, 19 Jul 2021, Rob Sargent wrote: >> >> > 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" > > Regards > > Pavel > >> >> Rich >> >> >> >>