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

Started by PG Bug reporting formabout 7 years ago1 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.