Simon Riggs escribió: > On 14 November 2012 15:09, Fujii Masao <masao.fu...@gmail.com> wrote: > > >> Here, progname for COPY IN is the user-supplied program that takes > >> filename as > >> its argument and that writes on standard output. > > > > What about further extending the COPY IN syntax to the following? > > > > COPY table_name FROM 'progname [ option, ... ]' WITH ... > > > > I'd just like to execute > > > > COPY vmstat_table FROM 'vmstat' WITH ... > > I think we should be using FDWs/SRFs here, not inventing new > syntax/architectures for executing external code, so -1 from me.
Hmm, but then you are forced to write C code, whereas the "external program" proposal could have you writing a only shell script instead. So there is some merit to this idea ... though we could have a "pipe_fdw" that could let you specify an arbitrary program to run. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
