Re: Let file_fdw access COPY FROM PROGRAM - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Let file_fdw access COPY FROM PROGRAM
Date
Msg-id CADkLM=eNZrtJJmB5DN1WgT7bU6tiiyWt2axW-oLFVVnVe4-usw@mail.gmail.com
Whole thread
In response to Re: Let file_fdw access COPY FROM PROGRAM  (Craig Ringer <craig.ringer@2ndquadrant.com>)
Responses Re: Let file_fdw access COPY FROM PROGRAM
List pgsql-hackers
On Tue, Sep 6, 2016 at 11:44 PM, Craig Ringer <craig.ringer@2ndquadrant.com> wrote:
On 7 September 2016 at 11:37, Corey Huinker <corey.huinker@gmail.com> wrote:
> On Tue, Sep 6, 2016 at 11:24 PM, Craig Ringer <craig.ringer@2ndquadrant.com>
> wrote:
>>
>> On 7 September 2016 at 11:21, Corey Huinker <corey.huinker@gmail.com>
>> wrote:
>> > On Tue, Sep 6, 2016 at 6:53 PM, Craig Ringer
>> > <craig.ringer@2ndquadrant.com>
>>
>> > And the TAP test would detect the operating system and know to create an
>> > FDW
>> > that has the PROGRAM value 'cat test_data.csv' on Unix, 'type
>> > test_data.csv'
>> > on windows, and 'type test_data.csv;1' on VMS?
>>
>> Right. Or just "perl emit_test_data.pl" that works for all of them,
>> since TAP is perl so you can safely assume you have Perl.
>
>
> Thanks. I was mentally locked in more basic OS commands. Am I right in
> thinking perl is about the *only* OS command you can be sure is on every
> architecture?

Probably, there's a lot of crazy out there.

TAP tests can be conditionally run based on architecture, but
something like this is probably worth testing as widely as possible.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


Stylistically, would a separate .pl file for the emitter be preferable to something inline like

perl -e 'print "a\tb\tcc\t4\n"; print "b\tc\tdd\t5\n"'

?

I'm inclined to go inline to cut down on the number of moving parts, but I can see where perl's readability is a barrier to some, and either way I want to follow established patterns.


[*] For those who don't perl, the command prints:
a       b       cc      4
b       c       dd      5

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Is tuplesort_heap_siftup() a misnomer?
Next
From: Tom Lane
Date:
Subject: Re: Is tuplesort_heap_siftup() a misnomer?