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?
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?
Attachment:
Everyone_Access.JPG
Description: JPEG image
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
