Re: [GENERAL] column names query - Mailing list pgsql-general

From Francisco Olarte
Subject Re: [GENERAL] column names query
Date
Msg-id CA+bJJbxAJ+WeoQvts9tMq19g+49AZAYQ3oC2e=stGr0_rNwhBw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] column names query  (hamann.w@t-online.de)
List pgsql-general
Hi Hamman:

On Thu, Sep 7, 2017 at 3:17 PM,  <hamann.w@t-online.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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] WAL & ready files retained after turning off log shipping
Next
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Confused about max_standby_streaming_delay