postgres C:: Permission denied using windows

Question

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.sql
C:: Permission denied

I get that Permission Denied

C:: Permission denied

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

Try forward slashes `\i c:/Users/Asus/Desktop/Projects/Movies/solution.sql` — , Jul 27 '21 at 14:07
I encountered the same problem, but after spending an hour searching the web, I stumbled upon your comment and your solution worked perfectly for me. Thank you so much for sharing! @a_horse_with_no_name — vetheve, Jan 10 '23 at 09:56

Sadra M. · Answer 1 · 2022-05-11T07:42:54.203

12

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.

edited May 11 '22 at 07:42

answered Apr 24 '22 at 10:19

Sadra M.

1,304
1
17
28

i still see the same error despite using forward slashes :/ – Awani Oct 28 '22 at 15:52

Sufyx · Answer 2 · 2022-11-19T14:25:51.927

0

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'

edited Nov 19 '22 at 14:25

answered Nov 19 '22 at 14:25

Sufyx

1
1

postgres C:: Permission denied using windows

2 Answers2