CODEWITHSUNDEEP
postgresqlcodepagespostgresql-copy
Petros Apotsos
Petros Apotsos

Reputation: 635

postgreSQL COPY command error

Hallo everyone once again,
I did various searches but couldn't gind a suitable/applicable answer to the simple problem below:
On pgAdminIII (Windows 7 64-bit) I am running the following command using SQL editor: 

COPY public.Raw20120113 FROM 'D:\my\path\to\Raw CSV Data\13_01_2012.csv';

I tried many different variations for the path name and verified the path, but I keep getting:

ERROR: could not open file "D:\my\path\to\Raw CSV Data\13_01_2012.csv" for reading: No such file or directory

Any suggestions why this happens?
Thank you all in advance
Petros

UPDATE!!

After some tests I came to the following conclusion: The reason I am getting this error is that the path includes some Greek characters. So, while Windows uses codepage 1253, the console is using 727 and this whole thing is causing the confusion. So, some questions arise, you may answer them if you like or prompt me to other questions?
1) How can I permanently change the codepageof the console?
2) How can I define the codepage is SQL editor? Thank you again, and sorry if the place to post the question was inappropriate!

Upvotes: 2

Views: 2618

Answers (2)

michal.jakubeczy
michal.jakubeczy

Reputation: 9469

The problem is that COPY command runs on server so it takes the path to the file from the server's scope.

To use local file to import you need to use \COPY command. This takes local path to the file into account and loads it correctly.

Upvotes: 0

Jayadevan
Jayadevan

Reputation: 1342

Try DIR "D:\my\path\to\Raw CSV Data\13_01_2012.csv" from command line and see if it works - just to ensure that you got the directory, file name, extension etc correct.

Upvotes: 2

Related Questions