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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org