Re: copy query results to file

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: copy query results to file
Date: 2011-12-14 10:37:29
Message-ID: CAP6d-HW6YGx1ef4ufm+PwQJ-3ehaJc+=8AwA41+Foqa_wHzHmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 14 December 2011 10:40, Thomas Kellerer <spam_eater(at)gmx(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Takahiro Noda 2011-12-15 04:55:51 The exact timing at which CHECK constraints are checked
Previous Message Thomas Kellerer 2011-12-14 08:40:36 Re: copy query results to file