MIME-Version: 1.0
References: <CACJO+64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D=tFHxvA@mail.gmail.com>
In-Reply-To: <CACJO+64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D=tFHxvA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 13 Feb 2026 17:23:38 -0500
Message-ID: <CANzqJaB16Uj6F62oJTHG7QXwgr2uN=vnFdr=Kv0k+yUuONn4fA@mail.gmail.com>
Subject: Re: Best practice for granting folder read/write permission on Windows
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003785a8064abc0f55"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB16Uj6F62oJTHG7QXwgr2uN%3DvnFdr%3DKv0k%2ByUuONn4fA%40mail.gmail.com>
Precedence: bulk

--0000000000003785a8064abc0f55
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 13, 2026 at 4:15=E2=80=AFPM Anthony DeBarros <anthonymdebarros@=
gmail.com>
wrote:

> Hi, all,
>
> I don=E2=80=99t use Windows much, but I often help folks who do and are l=
earning
> SQL by running PostgreSQL on that OS.
>
> In order to COPY FROM or TO a folder on, say, the Desktop, the user must
> first provide permission to PostgreSQL to Read and Write from it. Out of
> the box, it cannot as it does not have permission.
>
> Do any of you with PostgreSQL and Windows expertise have a suggestion on =
a
> best practice for this? I have through trial and error found that
> navigating to the folder Properties, and then Security, and adding =E2=80=
=9CUsers=E2=80=9D
> to the list of Group or user names solves the issue. I suppose I could fi=
nd
> the specific name of the PostgreSQL service and add it, but that=E2=80=99=
s a lot of
> digging for newbies.
>

I think the standard solution is to use psql and its \copy meta-command.
Since it runs in the client context, no special permissions are required.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000003785a8064abc0f55
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 13, 2026 at 4:15=E2=80=AFPM A=
nthony DeBarros &lt;<a href=3D"mailto:anthonymdebarros@gmail.com">anthonymd=
ebarros@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote=
_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div dir=
=3D"ltr">Hi, all,<div><br></div><div dir=3D"ltr">I don=E2=80=99t use Window=
s much, but I often help folks who do and are learning SQL by running Postg=
reSQL on that OS.=C2=A0</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">In=
 order to COPY FROM or TO a folder on, say, the Desktop, the user must firs=
t provide permission to PostgreSQL to Read and Write from it. Out of the bo=
x, it cannot as it does not have permission.</div><div dir=3D"ltr"><br></di=
v><div dir=3D"ltr">Do any of you with PostgreSQL and Windows expertise have=
 a suggestion on a best practice for this? I have through trial and error f=
ound that navigating to the folder Properties, and then Security, and addin=
g =E2=80=9CUsers=E2=80=9D to the list of Group or user names solves the iss=
ue. I suppose I could find the specific name of the PostgreSQL service and =
add it, but that=E2=80=99s a lot of digging for newbies.</div></div></div><=
/blockquote><div></div></div><div><br></div><div>I think the standard solut=
ion is to use psql and its \copy meta-command.=C2=A0 Since it runs in the c=
lient context, no special permissions are=C2=A0required.</div><div><br></di=
v><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cla=
ss=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butt=
er sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Reda=
cted&gt; lobster!</div></div></div></div></div></div>

--0000000000003785a8064abc0f55--