Re: Formating psql query output - Mailing list pgsql-general

From Rob Sargent
Subject Re: Formating psql query output
Date
Msg-id 59681104-A02E-46C3-8402-9A5F13DF9AE2@gmail.com
Whole thread Raw
In response to RE: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general

> On Jul 19, 2021, at 12:53 PM, Rich Shepard <rshepard@appl-ecosys.com> 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. 




pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Formating psql query output
Next
From: Rich Shepard
Date:
Subject: Re: Formating psql query output