file_fdw Access csv file on a remote server

Question

Creating a foreign table like this:

CREATE FOREIGN TABLE xxxx
(... )
SERVER file
OPTIONS (filename '/data/data.csv', format 'csv', delimiter ';'); 

In the filename Option, Is it possible to specify a csv file that is on a remote server or the file as to be on the DB server? Both DB and Application server are Centos.

Answer 1

You can not specify remote file for file_fdw.

filename

        Specifies the file to be read. Required. Must be an absolute path name.

The only one way access to remote file without copying - mount fs with it (nfs, samba, etc).