Re: Formating psql query output

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Formating psql query output
Дата
Msg-id 59681104-A02E-46C3-8402-9A5F13DF9AE2@gmail.com
обсуждение исходный текст
Ответ на RE: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Formating psql query output  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Formating psql query output
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Formating psql query output