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 по дате отправления: