How to set Postgres path variable on Windows 10

Question

I'm on a windows machine and I am having trouble fixing this error:

I've tried to modify the path variable based on various suggestions online but nothing seems to work. I've been at this for over an hour.

I'm curious what exactly I am suppose to do to have the path variable read.

I'm on Windows 10.

I think I need idiot proof step-by-step instructions.

Here is an example of one of my attempts:

When I run psql from the command prompt it is not recognized.

I initially typed windows 11...I meant windows 10. Sorry. If you could please remove the down vote I would appreciate it — William
– William, Commented Sep 20, 2016 at 19:17
What exactly did you try and are you sure it's a programming problem instead of a software question? — PeeHaa
– PeeHaa, Commented Sep 20, 2016 at 19:19
I added a screen shot of one example. But like I said , I've been at it for over an hour — William
– William, Commented Sep 20, 2016 at 19:28

score 16 · Accepted Answer · 2016-09-20 21:52:49Z

16

The PATH contains directories, not the actual executable.

And programs are installed in c:\Program Files not c:\Windows\Program Files.

So you need to add c:\Program Files\PostgreSQL\9.6\bin to the path.

edited Sep 20, 2016 at 21:52

answered Sep 20, 2016 at 20:07

user330315

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

Comments

mahnoor · Accepted Answer · 2021-02-05 19:33:51Z

3

first, you have to set the path for this go to program files search for PostgreSQL folder then a folder come click on it then you will see bin folder click on there where the arrow is pointing you will get the path like this C:\Program Files\PostgreSQL\13 copy it

then left-click on this PC, Click on properties Click on the advance system setting on your left hand side a prompt is open then click on an environment variable

Click on the path click on edit then click on new then paste this C:\Program Files\PostgreSQL\13

your environment is set then go to cmd type psql -U Postgres then type the password boom done

answered Feb 5, 2021 at 19:33

mahnoor

5701 gold badge6 silver badges20 bronze badges

1 Comment

Hicsy Over a year ago

why doesnt this get done when running the official installer?

Collectives™ on Stack Overflow

How to set Postgres path variable on Windows 10

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related