public inbox for [email protected]  

help / color / mirror / Atom feed

From: Anthony DeBarros <[email protected]>
To: [email protected]
Subject: Best practice for granting folder read/write permission on Windows
Date: Fri, 13 Feb 2026 13:14:50 -0800
Message-ID: <CACJO+64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D=tFHxvA@mail.gmail.com> (raw)

Hi, all,

I don’t use Windows much, but I often help folks who do and are learning
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 “Users”
to the list of Group or user names solves the issue. I suppose I could find
the specific name of the PostgreSQL service and add it, but that’s a lot of
digging for newbies.

I hope this question is clear. Thanks for any suggestions.

Anthony DeBarros

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Best practice for granting folder read/write permission on Windows
  In-Reply-To: <CACJO+64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D=tFHxvA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox