> Having regression tests for this is extremely problematic, because the program invoked would need to be an invokable command on any architecture supported by postgres. I'm pretty sure no such command exists.
Your best bet will be using the TAP framework. There you can use Perl logic.
I'm not sure where to put such a test though. It doesn't really make sense in src/test/recovery/ .
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?