Re: copy query results to file

From: Pandu Poluan <pandu(at)poluan(dot)info>
To: John Payne <jcpayne(at)uw(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: copy query results to file
Date: 2011-12-14 08:17:45
Message-ID: CAA2qdGXzHEs=X=eDW6jjs=0ZAv4tZy9E=EnSyEY9doL843W_=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Dec 14, 2011 3:06 PM, "John Payne" <jcpayne(at)uw(dot)edu> wrote:
>

----->8 snip

>
> Neither approach is working for me. 1) The COPY query doesn’t work on
views, and gives me an error when I try to run it as “COPY (select …). 2)
The psql produces output in an inconvenient format with pipe symbols and
headers and underlines.
>

One more question: Can't you clean up the output with a script?

Rgds,

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2011-12-14 08:40:36 Re: copy query results to file
Previous Message Pandu Poluan 2011-12-14 08:15:19 Re: copy query results to file