Hi All,
I am trying to utilize the "COPY" statement below to copy a .CSV file to a
table in a PostgreSQL database.:
*COPY <schema>.<table_name>(<table_columns>) FROM
'\\shared\network\path\to\csv\test.csv' DELIMITER ',' CSV HEADER;*
This works with a PostgreSQL database installed in a WINDOWS environment
(Windows 7), but fails with the following error with a similar PostgreSQL
database in a Linux environment (Centos 7):
*org.postgresql.util.PSQLException: ERROR: could not open file
"\\shared\network\path\to\csv\test.csv" for reading: No such file or
directory*
I have granted READ access to EVERYONE on the CSV folder on the network
path as depicted in the attached image.
Could someone point me to the reason for the failure in Linux?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
