file_fdw_program is an extension that provides a file_fdw-like foreign data wrapper, but which can read from an external command via the program
option.
This code is also a patch currently pending for the file_fdw contrib module in 10.0.
For function documentation and examples, see the file_fdw_program.md file.
Requirements: PostgreSQL 9.4 or greater.
In the directory where you downloaded file_fdw_program, run
make && make install
Log into PostgreSQL.
Run the following command:
CREATE EXTENSION file_fdw_program;
Run "make && make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:
ALTER EXTENSION file_fdw_program UPDATE TO '<latest version>';