Re: COPY (query) TO file

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: COPY (query) TO file
Дата
Msg-id 4480AC06.5030103@wildenhain.de
обсуждение исходный текст
Ответ на Re: COPY (query) TO file  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: COPY (query) TO file  (Greg Stark <gsstark@mit.edu>)
Re: COPY (query) TO file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Tino Wildenhain <tino@wildenhain.de> writes:
>> Ok, but why not just implement this into pg_dump or psql?
>> Why bother the backend with that functionality?
> 
> You're not seriously suggesting we reimplement evaluation of WHERE clauses
> on the client side, are you?

no, did I? But what is wrong with something like:

\COPY 'SELECT foo,bar,baz FROM footable WHERE baz=5 ORDER BY foo' TO
file|stdout

which would just run the query (in the backend of course) and
format the output just like copy would...

I mean, ok, when its in the backend, its fine too (beside the
data expansion if you dont implement compression...)
but I thougt implementing in the frontend would be easier...

Regards
Tino


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mark Woodward"
Дата:
Сообщение: Re: COPY (query) TO file
Следующее
От: Jim Nasby
Дата:
Сообщение: bgwriter statistics