Postgres C:: Permission denied using windows

I am using Windows 10

I have a PostgreSQL file when I run inside the PSQL CMD

\i FILENAMEPATH

postgres=# \i C:\Users\Asus\Desktop\Projects\Movies\solution.sqlC:: Permission denied

I get that Permission Denied

C:: Permission denied

Is there a way around this? Or how can I gain permission?

2

Best Answer

As a_horse_with_no_name pointed out, using forward slashes instead of backslashes in the address solves the problem.

This is because windows unlike most OSs, resolves paths with forward slashes.

What solved this issue for me is opening a PowerShell in the folder location of the sql file (in folder: shift + right-click -> open PowerShell here), to avoid having to provide a file path, and then running '\i filename.sql'

Random Posts

How do you auto format code in Visual Studio?How to set-up a docker registry acting as a Proxy?Is Aurora Serverless V1 deprecated?subtract from number IF statmentWhich HTML5 tag should I use to mark up an author’s name?AWS SQS ReceiveMessage receiving less / fewer messages than requested?Vim: <leader>h mapping slowWhat would I use git-worktree for?AADSTS75011 Authentication method by which the user authenticated with the service doesn't match requested authentication method AuthnContextClassRefHow to escape liquid template tags?How to find which points intersect with a polygon in geopandas?Can we connect firebase database with Webflow?What are the compression types supported in parquetHow can I make a modal like in the picture - discordWhere are attachments stored in a SharePoint list?Start a background process in PythonHow to define a vector functionHow to assign a unique ID to a google form input?logistic regression get the sm.Logit values (python, statsmodels)Convert binary file to image