Re: COPY (query) TO file - Mailing list pgsql-hackers

From Mark Woodward
Subject Re: COPY (query) TO file
Date
Msg-id 18743.24.91.171.78.1149297941.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: COPY (query) TO file  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: COPY (query) TO file
Re: COPY (query) TO file
Re: COPY (query) TO file
List 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.

There is an important difference between a capability in the backend vs
one synthesized in the frontend.


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: COPY (query) TO file
Next
From: "Joshua D. Drake"
Date:
Subject: Re: COPY (query) TO file