Re: Linux file permission for COPY TO SQL command

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Krzysztof <kj(at)limes(dot)com(dot)pl>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Linux file permission for COPY TO SQL command
Date: 2025-10-28 23:03:07
Message-ID: 8ABD45BB-37B7-4394-AB59-10BC1C25797F@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Oct 28, 2025, at 9:39 AM, Krzysztof <kj(at)limes(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Roland Müller 2025-10-29 16:12:59 Re: Linux file permission for COPY TO SQL command
Previous Message Krzysztof 2025-10-28 19:39:17 Linux file permission for COPY TO SQL command