Postgresql COPY command issue

Question

copy (select * from TABLE_NAME) TO '/home/name/teste.csv';

This is the command line, it seems pretty simple I've read the documentation on this link (https://www.postgresql.org/docs/9.6/sql-copy.html), checked my postgresql version and when I run the code it gives me this error

ERROR:  could not open file "/home/name/teste.csv" for writing: No such file or directory

********** Error **********

ERROR: could not open file "/home/name/teste.csv" for writing: No such file or directory
SQL state: 58P01

The file is there, checked with 'pwd' the path an everything seems ok, also tried the code with "WITH CSV" in the end and nothing. Anyone seeing something I'm not?

The path needs to exist on the server and the OS user that runs the server needs to have the privileges to write there — user330315
– user330315, Commented Nov 19, 2019 at 18:51
It does, the csv files has the privileges and postgresql also (pgadmin in my case) — Pablo Azevedo
– Pablo Azevedo, Commented Nov 19, 2019 at 19:23
pgAdmin runs on the client, not on the server. So giving "pgAdmin" privileges (whatever that is supposed to mean) is not enough. — user330315
– user330315, Commented Nov 19, 2019 at 19:36

Laurenz Albe · Accepted Answer · 2019-11-19 22:52:53Z

1

For this command to work, there needs to be /home/name on the database server, and the operating system user postgres must have write access to that directory.

answered Nov 19, 2019 at 22:52

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jim Jones · Accepted Answer · 2019-12-19 11:21:04Z

0

The file teste.csv needs to be placed in the directory home/name/ in the database server, not in the client. The database user also needs to have the necessary permissions to access the file.

An option to do that without moving the file into the database server is to use the stdin of psql from your client console:

$ cat teste.csv | psql yourdb -c "COPY tabela_teste FROM STDIN;"

abs!

edited Dec 19, 2019 at 11:21

answered Nov 20, 2019 at 9:46

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Collectives™ on Stack Overflow

Postgresql COPY command issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related