Re: [GENERAL] column names query

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: [GENERAL] column names query
Дата
Msg-id CA+bJJbxAJ+WeoQvts9tMq19g+49AZAYQ3oC2e=stGr0_rNwhBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] column names query  (hamann.w@t-online.de)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] WAL & ready files retained after turning off log shipping
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Confused about max_standby_streaming_delay