Set PostgreSQL environment variables

If we dont set PostgreSQL environmental variable, We cannot access PostgreSQL through the command line in Windows.But, we can access PostgreSQL using pgAdmin or SQL Shell(psql). To access the PostgreSQL through command line in window, follow the below steps.

Set PostgreSQL environment variables

Set PostgreSQL environment variables

1. Right Click on My Computer(This PC)–> Select properties–> Advanced System Settings–>Click on Environment Variables

2. Select the path from System Variables and click on Edit.

3. Then, click New and paste following path in the new line as shown below.

4. Click ok twice.

5. Open the command line utility and run the psql or psql -?

The above is solution for below error also.

C:\Users\pinnapav>psql -? 'psql' is not recognized as an internal or external command, operable program or batch file. C:\Users\pinnapav>psql 'psql' is not recognized as an internal or external command, operable program or batch file.

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: