BUG #16798: SQL Error

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16798: SQL Error
Дата
Msg-id 16798-79d0596541ca9bad@postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16798
Logged by:          Oluwasola Arigbabowo
Email address:      ok.arigbabowo@gmail.com
PostgreSQL version: 10.0
Operating system:   Windows 10
Description:

Hi,
I encountered an error when I was trying to copy a csv file into a table
created in a database inside the server. The code I used is :

Copy Customer from 'C:\\Users\\okari\\Customer.csv' delimiter ',' csv
header;

and the error that resulted is given below.

ERROR:  could not open file "C:\\Users\\okari\\Customer.csv" 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.
SQL state: 42501

I would appreciate some help with this.

Thanks
OK


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16799: postgresql log issue(last completed transaction was at log time)