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

From Pandu Poluan
Subject Re: copy query results to file
Date
Msg-id CAA2qdGXzHEs=X=eDW6jjs=0ZAv4tZy9E=EnSyEY9doL843W_=g@mail.gmail.com
Whole thread Raw
In response to copy query results to file  ("John Payne" <jcpayne@uw.edu>)
List pgsql-novice


On Dec 14, 2011 3:06 PM, "John Payne" <jcpayne@uw.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,

pgsql-novice by date:

Previous
From: Pandu Poluan
Date:
Subject: Re: copy query results to file
Next
From: Thomas Kellerer
Date:
Subject: Re: copy query results to file