]> granicus.if.org Git - postgresql/commit
Allow contrib/file_fdw to read from a program, like COPY FROM PROGRAM.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 29 Sep 2016 17:32:27 +0000 (13:32 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 29 Sep 2016 17:32:34 +0000 (13:32 -0400)
commit8e91e12bc3af85ba2287866669268f6825d2cc03
treea44bfbe353b0ceb92a4170c6118db5ec40b86e10
parent728a3e73e96173bb0b0b2afc0da061991f9e3d5d
Allow contrib/file_fdw to read from a program, like COPY FROM PROGRAM.

This patch just exposes COPY's FROM PROGRAM option in contrib/file_fdw.
There don't seem to be any security issues with that that are any worse
than what already exist with file_fdw and COPY; as in the existing cases,
only superusers are allowed to control what gets executed.

A regression test case might be nice here, but choosing a 100% portable
command to run is hard.  (We haven't got a test for COPY FROM PROGRAM
itself, either.)

Corey Huinker and Adam Gomaa, reviewed by Amit Langote

Discussion: <CADkLM=dGDGmaEiZ=UDepzumWg-CVn7r8MHPjr2NArj8S3TsROQ@mail.gmail.com>
contrib/file_fdw/file_fdw.c
contrib/file_fdw/output/file_fdw.source
doc/src/sgml/file-fdw.sgml