|pgAdmin On Windows|
PostgresSQL is an Open Source Database System. The Postgres developers are developing for more than 15 years, that earned Postgres to be strong database. It works on most of all Operating Systems. It supports foreign keys, triggers, views and stored procedures.
How to configure Postgres in Windows ?
Installing PostgresSQL First :
# Step 1 :
Double click the downloaded PostgresSQL Win32 file, and Click "next" in the windows installer.
# Step 2 :
There you can see to select the folder. Default location will be in "c:/program files/PostgreSQL/". Never need to change the default directory. Or else you can change it and point to the Folder You wanted.
|Setup Directory For Postgres|
On the next step it will ask for the "Data" directory. and click next.
# Step 3 :
Next it will ask for the "Database - Passwords". The new password will be your Database Password. You have to remember this password for the future reference.
Give my favorite Password : root
|Password For Database|
# Step 4 :
Then just click Install. That's it you have installed PostgresSQL in your windows PC.
Now you want to install and Interface to work with SQL Queries.
So you need to download pgAdmin III
It is a ZIP file. You have to extract it and double click the pgadmin3.exe file. Please accept the terms and conditions and click next --> next --> install
You can now see pgAdmin3 successfully installed.
|pgAdmin3 installed on the computer|
Now open pgAdmin III icon from the start menu.
There you can see Servers - PostgresSQL 9.2(localhost:5432) , Double click on that it will ask for Database Password that we have given in Step 3. Enter it and start writing your SQL Queries.