Using file_fdw to load tsv file into Foreign Table gives Permission denied error

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: vipulcp1809(at)gmail(dot)com
Subject: Using file_fdw to load tsv file into Foreign Table gives Permission denied error
Date: 2019-02-23 11:47:58
Message-ID: 155092247881.1380.8787497850816936733@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/file-fdw.html
Description:

CREATE EXTENSION file_fdw;
CREATE SERVER svr_file FOREIGN DATA WRAPPER file_fdw;
CREATE FOREIGN TABLE fdt_topups (seq integer , id_user integer ,
topup_date date , topup_value integer ) SERVER svr_file OPTIONS ( format
'csv', header 'true', filename 'C:/Users/Vipul/Downloads/topups.tsv',
delimiter E'\t', null '');

ERROR: could not open file "C:/Users/Vipul/Downloads/topups.tsv" for
reading: Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You
may want a client-side facility such as psql's \copy.

Browse pgsql-docs by date

  From Date Subject
Next Message Jürgen Purtz 2019-02-23 17:06:55 Re: First SVG graphic
Previous Message Bruce Momjian 2019-02-22 20:29:01 Re: Improve documentation for current_setting function