Linux file permission for COPY TO SQL command

From: Krzysztof <kj(at)limes(dot)com(dot)pl>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Linux file permission for COPY TO SQL command
Date: 2025-10-28 19:39:17
Message-ID: f1072845-ca23-46de-bbf2-41acbae3a97e@limes.com.pl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I try to use COPY TO command to copy results of a SELECT but I get this
message:

ERROR:  could not open file "a file" for writing: Permission denied

User, group and other are granted full permission to this file. What
should I do more to get this working?

--
Pozdrawiam
Krzysztof Jasieński

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2025-10-28 23:03:07 Re: Linux file permission for COPY TO SQL command
Previous Message Orwa Diraneyya 2025-08-28 09:38:26 PostgreSQL Extension Hot-Reload Pattern (Using a Dummy "noop" Version)