Rod Taylor wrote:
>On Wed, 2005-09-21 at 15:25 -0700, Trent Shipley wrote:
>
>
>>
>>Wouldn't you also need a CREATE TEMP TABLE privilege but the
>>COPY TO file USING select_statement
>>would only need select. (In other words using a temp table would not seem to
>>be as secure nor as general as the requested feature.)
>>
>>
>
>Writing a file on the server requires significant privilege, including
>access to the server itself so you can retrieve the results.
>
>
But we also do COPY to STDOUT which requires no special privileges on
the server.
Incidentally, if we are going to allow copy out from views, it would be
nice and orthogonal to allow copy in too. Hasn't there been some talk
about making automatically writeable views?
cheers
andrew