Hi I'm getting an error when reading from a file_fdw table in a Windows environment. Any hints? (see below).
And http://www.postgresql.org/docs/9.1/static/file-fdw.html is not really verbose :-> At least following format options should be mentioned: 'xml', 'text', 'csv', 'binary'. Yours, Stefan That's what I'm doing: CREATE EXTENSION file_fdw; CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw; CREATE FOREIGN TABLE foreignfiletable(id text, title text) SERVER file_server OPTIONS(format 'csv', header 'true', filename 'C:/Users/someuser/Downloads/file.csv', delimiter '|', null ''); SELECT * FROM foreignfiletable; -- ERROR: file »C:/Users/someuser/Downloads/file.csv« could not be opened for reading: Permission denied. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
