Content-Type: multipart/alternative;
 boundary=Apple-Mail-871FE16D-84E7-42B0-B0DC-CDC070C35D51
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Linux file permission for COPY TO SQL command
Date: Tue, 28 Oct 2025 13:03:07 -1000
Message-Id: <8ABD45BB-37B7-4394-AB59-10BC1C25797F@gmail.com>
References: <f1072845-ca23-46de-bbf2-41acbae3a97e@limes.com.pl>
Cc: pgsql-sql@lists.postgresql.org
In-Reply-To: <f1072845-ca23-46de-bbf2-41acbae3a97e@limes.com.pl>
To: Krzysztof <kj@limes.com.pl>
Archived-At: 
 <https://www.postgresql.org/message-id/8ABD45BB-37B7-4394-AB59-10BC1C25797F%40gmail.com>
Precedence: bulk


--Apple-Mail-871FE16D-84E7-42B0-B0DC-CDC070C35D51
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable


> On Oct 28, 2025, at 9:39=E2=80=AFAM, Krzysztof <kj@limes.com.pl> wrote:
>=20
> =EF=BB=BF
> I try to use COPY TO command to copy results of a SELECT but I get this me=
ssage:
>=20
> ERROR:  could not open file "a file" for writing: Permission denied
>=20
>=20

Is there really a space in the actual file name. That might get tricky. You=E2=
=80=99re suggesting the file already exists: is that true? Directory permiss=
ions?
> User, group and other are granted full permission to this file. What shoul=
d I do more to get this working?
>=20
> --=20
> Pozdrawiam
> Krzysztof Jasie=C5=84ski

--Apple-Mail-871FE16D-84E7-42B0-B0DC-CDC070C35D51
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br=
></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Oct 28, 2025, at 9:=
39=E2=80=AFAM, Krzysztof &lt;kj@limes.com.pl&gt; wrote:<br><br></blockquote>=
</div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF

 =20

    <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF-8"=
>
 =20
 =20
    <p>I try to use COPY TO command to copy results of a SELECT but I
      get this message:</p>
    <p>
      <span style=3D"font-family:monospace"><span style=3D"color:#000000;bac=
kground-color:#ffffff;">ERROR: &nbsp;could
          not open file "a file" for writing: Permission denied</span><br>
        <span style=3D"color:#000000;background-color:#ffffff;"></span><br><=
/span></p></div></blockquote><div><br></div>Is there really a space in the a=
ctual file name. That might get tricky. You=E2=80=99re suggesting the file a=
lready exists: is that true? Directory permissions?<br><blockquote type=3D"c=
ite"><div dir=3D"ltr"><p><span style=3D"font-family:monospace">
        User, group and other are granted full permission to this file.
        What should I do more to get this working?</span></p>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Pozdrawiam
Krzysztof Jasie=C5=84ski
</pre>
 =20

</div></blockquote></body></html>=

--Apple-Mail-871FE16D-84E7-42B0-B0DC-CDC070C35D51--