Added to TODO: o Allow COPY to output from views
--------------------------------------------------------------------------- Andrew Dunstan wrote: > > > 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 > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org