Re: csv format for psql

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: csv format for psql
Дата
Msg-id CAKFQuwZKtjuGgOW=ZEn9Ku+2SxVkf1T13cU-NXHv9K3fkUL-Gg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: csv format for psql  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: csv format for psql  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: csv format for psql  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-hackers
On Wednesday, March 28, 2018, Pavel Stehule <pavel.stehule@gmail.com> wrote:

Are there some possible alternatives?

Given the date and the fact that the cf end is 3 days away, the proposed short term alternative is Daniel's version, that I feel is reasonable. Ok, people have to do two pset to get comma-separated csv, otherwise they get pipe-separated csv in one pset.


Could someone post how captions, rows-only, and footer pset settings factor into this?  Specifically are they fixed to on/off or will they hide/show if users request them explicitly?

My take on this is that --csv mode is/should be an alternate output mode from the existing pset controlled one, and functions basically like "\copy to stdout" and all echoing and metadata outputs are disabled and only query results, with header and the user specified delimiter, are output.  No control other than the delimiter seems to be provided in the current design but that could be expanded upon.  In that specification the existing fieldsep argument that is tied to pset should not be used and something like --csv-fieldsep should be provided (I like the prefixing to tie the option lexically to the master --csv option).

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [bug fix] pg_rewind creates corrupt WAL files, and the standbycannot catch up the primary
Следующее
От: Keiko Oda
Дата:
Сообщение: Re: Trigger file behavior with the standby