Search Postgresql Archives

Re: Formating psql query output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Jul 19, 2021, at 12:53 PM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
> 
> On Mon, 19 Jul 2021, Basques, Bob (CI-StPaul) wrote:
> 
>> -F separator
>> --field-separator=separator
>> Use separator as the field separator for unaligned output. This is equivalent to \pset fieldsep or \f.
> 
> Bobb,
> 
> I should have mentioned that I tried that. Without the --csv option the results
> have the headings and separator. With --csv the field separator is ignored
> regardless of postion within the command string.
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.







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux