Lesson 2of 2

Fix 'psql' is not recognized on Windows

Solutions to fix the 'psql' is not recognized error on Windows by adding PostgreSQL to PATH or reinstalling PostgreSQL with psql.

You are getting the error:

'psql' is not recognized as an internal or external command,
operable program or batch file.

This means PostgreSQL’s bin folder is not added to the Windows PATH, or PostgreSQL/psql is not installed.

Let’s fix it.

✅ Solution 1: Add PostgreSQL to PATH (Most likely fix)

Find the PostgreSQL installation folder Normally located at:
```
C:\Program Files\PostgreSQL\16\bin
```
(or version 15/14 depending on your install)
Copy the bin folder path Example:
```
C:\Program Files\PostgreSQL\16\bin
```
Add to Windows PATH
- Press Windows Key → type "Environment Variables"
- Open Edit the system environment variables
- Click Environment Variables
- Under System variables, select Path → Edit
- Click New → paste the bin path (e.g., C:\Program Files\PostgreSQL\16\bin)
- Click OK
Restart Command Prompt
Test again:
```
psql --version
```

You should now see something like:

psql (PostgreSQL) 16.x

If you cannot find the folder:

Make sure psql is selected during installation.

Many users install pgAdmin 4 only, not PostgreSQL itself. pgAdmin does not include psql.

In that case, reinstall PostgreSQL using the official installer.