How to fix \i 'file location' query in postgresql command line in windows 10 showing permission denied?

Question

I tried to execute '\i file_location' query in postgresql command line.I tried solving it by giving two different file paths i.e C://Users/public/person.sql and F://data//person.sql but it didn't work at all showing error as permission denied.

Well, give the PostgreSQL server permission.

Laurenz Albe
– Laurenz Albe

2020-09-21 14:29:33 +00:00
Commented Sep 21, 2020 at 14:29 — Laurenz Albe
– Laurenz Albe, Commented Sep 21, 2020 at 14:29

JGH · Accepted Answer · 2020-09-21 14:40:30Z

1

The path must be specified using slashes (as in your question). If you use backslashes, as in your picture, you will get this permission denied error.

==> use slashes.

\i D:\temp\sel.sql
D:: Permission denied
\i D:/temp/sel.sql
SET

answered Sep 21, 2020 at 14:40

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fix \i 'file location' query in postgresql command line in windows 10 showing permission denied?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related