Re: COPY (query) TO file

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: COPY (query) TO file
Дата
Msg-id 4480DC43.3040209@commandprompt.com
обсуждение исходный текст
Ответ на Re: COPY (query) TO file  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: COPY (query) TO file  ("Mark Woodward" <pgsql@mohawksoft.com>)
Список pgsql-hackers
>>  Allow COPY to output from views
>>  Another idea would be to allow actual SELECT statements in a COPY.
>>
>> Personally I strongly favor the second option as being more flexible
>> than the first.
> 
> 
> I second that - allowing arbitrary SELECT statements as a COPY source
> seems much more powerful and flexible than just supporting COPY FROM VIEW.

Not to be a sour apple or anything but I don't see how any of this is 
needed in the backend since we can easily use Psql to do it, or pretty 
much any other tool.

Joshua D. Drake

> 
> 
> Stefan
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 


-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/
 




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: More thoughts about planner's cost estimates
Следующее
От: "Mark Woodward"
Дата:
Сообщение: Re: COPY (query) TO file