From: | Stefan Keller <sfkeller(at)gmail(dot)com> |
---|---|
To: | pgsql-general List <pgsql-general(at)postgresql(dot)org> |
Subject: | Permission denied in file_fdw (Windows) |
Date: | 2012-12-04 23:39:06 |
Message-ID: | CAFcOn29AMksREVS_0ef82iA1y62n+Q=412gVj6acKJhzKpBv1Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2012-12-04 23:48:39 | Re: Permission denied in file_fdw (Windows) |
Previous Message | Lonni J Friedman | 2012-12-04 22:44:33 | Re: Postgresql logfilename and times in GMT - not EST |