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

From Rob Sargent
Subject Re: Linux file permission for COPY TO SQL command
Date
Msg-id 8ABD45BB-37B7-4394-AB59-10BC1C25797F@gmail.com
Whole thread Raw
In response to Linux file permission for COPY TO SQL command  (Krzysztof <kj@limes.com.pl>)
Responses Re: Linux file permission for COPY TO SQL command
List pgsql-sql


On Oct 28, 2025, at 9:39 AM, Krzysztof <kj@limes.com.pl> wrote:



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


Is there really a space in the actual file name. That might get tricky. You’re suggesting the file already exists: is that true? Directory permissions?

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

-- 
Pozdrawiam
Krzysztof Jasieński

pgsql-sql by date:

Previous
From: Krzysztof
Date:
Subject: Linux file permission for COPY TO SQL command
Next
From: Roland Müller
Date:
Subject: Re: Linux file permission for COPY TO SQL command