Обсуждение: Using file_fdw to load tsv file into Foreign Table gives Permission denied error

Поиск
Список
Период
Сортировка

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

От
PG Doc comments form
Дата:
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.