Re: copy query results to file - Mailing list pgsql-novice

From Michael Wood
Subject Re: copy query results to file
Date
Msg-id CAP6d-HW6YGx1ef4ufm+PwQJ-3ehaJc+=8AwA41+Foqa_wHzHmQ@mail.gmail.com
Whole thread Raw
In response to Re: copy query results to file  (Thomas Kellerer <spam_eater@gmx.net>)
List 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 by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: copy query results to file
Next
From: Takahiro Noda
Date:
Subject: The exact timing at which CHECK constraints are checked