Permission denied in file_fdw (Windows)
От | Stefan Keller |
---|---|
Тема | Permission denied in file_fdw (Windows) |
Дата | |
Msg-id | CAFcOn29AMksREVS_0ef82iA1y62n+Q=412gVj6acKJhzKpBv1Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Permission denied in file_fdw (Windows)
Re: Permission denied in file_fdw (Windows) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: