Re: PostgreSQL COPY Statement Error On Linux

From: "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org>
To: "'Osahon Oduware'" <osahon(dot)gis(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL COPY Statement Error On Linux
Date: 2017-09-12 11:01:26
Message-ID: 092201d32bb6$867eb750$937c25f0$@swisspug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Osahon Oduware
Sent: Dienstag, 12. September 2017 12:30
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] PostgreSQL COPY Statement Error On Linux

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 <file:///\\shared\network\path\to\csv\test.csv> " for reading: No such file or directory

It looks like the share is not visible for the Linux system. You probably need to mount it first using Samba and then access it through the mount point using slashes instead of bakslashes: /

Instructions on how to mount a Windows share in Linux can be found on the internet. Since I am not an expert on this myself, I can’t give you more concrete instructions.

This may help: http://www.serverlab.ca/tutorials/linux/storage-file-systems-linux/mounting-smb-shares-centos-7/

An alternative would be to copy the file to the Linux system using e.g. scp of sftp and the load it locally.

Hope this helps.

Bye

Charles

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2017-09-12 11:13:58 Re: Joining 16 tables seems slow
Previous Message Francisco Olarte 2017-09-12 11:00:20 Re: PostgreSQL COPY Statement Error On Linux