From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PostgreSQL COPY Statement Error On Linux |
Date: | 2017-09-12 10:30:02 |
Message-ID: | CAGpiUSi8JOxLK6q0o3ZJgRfCSmStpF-TOBcYAd3+-MBFQ5SDWg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Attachment | Content-Type | Size |
---|---|---|
|
image/jpeg | 57.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2017-09-12 10:39:49 | Re: Joining 16 tables seems slow |
Previous Message | Frank Millman | 2017-09-12 10:25:43 | Re: Joining 16 tables seems slow |