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

The chcp command is used to supplement the international keyboard and character set information, allowing MS-DOS to be used in other countries and with different languages. Before the chcp command can be used, the nlsfunc must be loaded, and the country.sys must be loaded into the config.sys.

Discussion:

Error ::- “ 'more' is not recognized as an internal or external command, operable program or batch file. “

Hi All,

Can anyone tel me what does this error mean. “ 'more' is not recognized as
an internal or external command, operable program or batch file. “

C:\Program Files\PostgresPlus\8.4\bin>psql -d postgres -p 5456 -U postgres
psql (8.4rc1)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.

postgres=# \l

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

"more" exists in C:\Windows\System32. So, please set the path in PATH
Environment Variable. and then try.
My Computer (Right Click) -> Properties -> then go to Advanced tab ->
Environment Variable -> set the path.

Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com

Post by raghu ram
Hi All,
Can anyone tel me what does this error mean. “ 'more' is not
recognized as an internal or external command, operable program or
batch file. “
C:\Program Files\PostgresPlus\8.4\bin>psql -d postgres -p 5456 -U postgres
psql (8.4rc1)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# \l
'more' is not recognized as an internal or external command,
operable program or batch file.

--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

It worked, Thaks!!!!!!!

Post by Vibhor Kumar
"more" exists in C:\Windows\System32. So, please set the path in PATH
Environment Variable. and then try.
My Computer (Right Click) -> Properties -> then go to Advanced tab ->
Environment Variable -> set the path.
Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com

Post by raghu ram
Hi All,
Can anyone tel me what does this error mean. “ 'more' is not recognized as
an internal or external command, operable program or batch file. “
C:\Program Files\PostgresPlus\8.4\bin>psql -d postgres -p 5456 -U postgres
psql (8.4rc1)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# \l
'more' is not recognized as an internal or external command,
operable program or batch file.

Loading...

1. Home
2. Windows
3. Postgres Quotpsql Not Recognized As An Internal Or External Commandquot

Postgres "psql not recognized as an internal or external command"

Tags: windows , postgresql , command-line Answers: 1 | Viewed 147,373 times

For Postgres, I keep getting this error multiple times even though I have already set the location of the bin folder to the path variable in Windows 8. Is there something else I'm missing?

(I can't post pictures since I don't have enough reputation)

Shahin answer at 2016-07-10 159

Just an update because I was trying it on Windows 10 you do need to set the path to the following:
;C:\Program Files\PostgreSQL\9.5\bin ;C:\Program Files\PostgreSQL\9.5\lib

You can do that either through the CMD by using set PATH [the path]
or from my

computer => properties => advanced system settings=> Environment
Variables => System Variables

Then search for path.

Important: don't replace the PATHs that are already there just add one beside them as follows ;C:\Program Files\PostgreSQL\9.5\bin ;C:\Program Files\PostgreSQL\9.5\lib

Please note: On windows 10, if you follow this: computer => properties => advanced system settings=> Environment Variables => System Variables> select PATH, you actually get the option to add new row. Click Edit, add the /bin and /lib folder locations and save changes.

Then close your command prompt if it's open and then start it again
try psql --version
If it gives you an answer then you are good to go if not try echo %PATH% and see if the path you set was added or not and if it's added is it added correctly or not.

Important note:

Replace 9.5 with your current version number. As of 2021, that is 13

* The answers/resolutions are collected from stackoverflow, are licensed under CC BY-SA 4.0

Some Code Answers

pg_ctl -D "C:\Program Files\PostgreSQL\11.4\data" start

C:\Program Files\PostgreSQL\[YOUR PG VERSION]\bin

C:\Program Files\PostgreSQL\10\bin C:\Program Files\PostgreSQL\10\lib

;C:\Program Files\PostgreSQL\9.5\bin ;C:\Program Files\PostgreSQL\9.5\lib

;C:\Program Files\PostgreSQL\[Your Version]\bin ;C:\Program Files\PostgreSQL\[Your Version]\lib

;C:\Program Files\PostgreSQL\<installed version>\bin;C:\Program Files\PostgreSQL\<installed version>\lib

C:\Users\LENOVO\Documents\postgresql-9.5.21-1-windows-x64-binaries (1)\pgsql\bin

C:\Users\LENOVO\Documents\postgresql-9.5.21-1-windows-x64-binaries (1)\pgsql\bin>pg_ctl -D "C:\usr\local\pgsql\data" start

C:\Program Files\PostgreSQL\yourversion

Please leave your answer here:

Why is psql not working?

Where is psql located Windows?

How do I start PostgreSQL on Windows command line?

Is not recognized as an internal or external command operable program or batch file?