Re: copy query results to file

Поиск
Список
Период
Сортировка
От Michael Wood
Тема Re: copy query results to file
Дата
Msg-id CAP6d-HW6YGx1ef4ufm+PwQJ-3ehaJc+=8AwA41+Foqa_wHzHmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: copy query results to file  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-novice
On 14 December 2011 10:40, Thomas Kellerer <spam_eater@gmx.net> wrote:
[...]
> You can use the options:
>
> \t
> \a
> \pset fieldsep ,
>
> to get a more "CSV" like output in psql.

I think it's worth mentioning that this is "CSV-like" and not actual
CSV.  It that doesn't work if you have any commas in your data.

As you say you could set the field separator to something else.

--
Michael Wood <esiotrot@gmail.com>

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: copy query results to file
Следующее
От: Takahiro Noda
Дата:
Сообщение: The exact timing at which CHECK constraints are checked