Re: Linux file permission for COPY TO SQL command - Mailing list pgsql-sql

That helped. Thanks.

Pozdrawiam
Krzysztof Jasieński

On 10/29/25 8:55 PM, Tom Lane wrote:
> The /home and /home/kaj directories would also need to be
> world-searchable for the server to be able to write there.
> (Do not make them world-writable...)
>
> Did you notice the HINT that goes with that error message?
>
> HINT:  COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as
psql's\copy.
 
>
>             regards, tom lane
>
>