| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | hamann(dot)w(at)t-online(dot)de |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: column names query |
| Date: | 2017-09-07 15:11:14 |
| Message-ID: | CA+bJJbxAJ+WeoQvts9tMq19g+49AZAYQ3oC2e=stGr0_rNwhBw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Hamman:
On Thu, Sep 7, 2017 at 3:17 PM, <hamann(dot)w(at)t-online(dot)de> wrote:
> I would like to do something like
> \copy (select heading(select .... my query here)) to /tmp/heading_testfile1
It's already been pointed out, you can do something using CSV copy
with headers ( Why headers are not allowed in other formats remains a
mistery to me), and LIMIT 0 ( I would try adding AND FALSE to the
where clause better, it may lead to faster response, although I doubt
it) .
Francisco Olarte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2017-09-07 16:08:21 | Re: Confused about max_standby_streaming_delay |
| Previous Message | Tom Lane | 2017-09-07 14:32:23 | Re: WAL & ready files retained after turning off log shipping |