Simon Riggs <[email protected]> writes:
> On 14 November 2012 15:09, Fujii Masao <[email protected]> wrote:
>> I'd just like to execute
>> COPY vmstat_table FROM 'vmstat' WITH ...
> If we go ahead with this, I think it needs additional keyword to
> indicate that we will execute the file rather than read from it. I
> don't think we should rely on whether the file is executable or not to
> determine how we should treat it.
Agreed, and there's also the question of passing switches etc to the
program, so the string can't be a bare file name anyway. I proposed
pipe symbols (|) in the string previously, but if you find that too
Unix-centric I suppose we could do
COPY TABLE FROM PROGRAM 'command line';
COPY TABLE TO PROGRAM 'command line';
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
