Database Reference
In-Depth Information
After installing PostgreSQL on Windows, you need to set the PATH environment variable
so that the
psql
,
pg_dump
and
pg_restore
commands can work through the Com-
mand Prompt. Perform the following steps:
1. Open
My Computer
.
2. Right-click on
My Computer
and select
Properties
.
3. Click on
Advanced System Settings
.
4. Click on the
Environment Variables
button.
5. From the
System variables
box, select the
Path
variable.
6. Click on
Edit
.
7. At the end of the line, add the bin directory of PostgreSQL:
c:\Program
Files\PostgreSQL\9.4\bin;c:\Program
Files\PostgreSQL\9.4\lib
.
8. Click on the
OK
button to save.
Note
The directory follows the pattern
c:\Program
Files\PostgreSQL\VERSION\...
, check your PostgreSQL version.