PostgreSQL COPY Statement Error On Linux

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

Responses

Browse pgsql-general by date

  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