HOW TO INSTALL POSTGRESQL IN WINDOWS XP
Download from :
Click Here to Download
After Download Follow This link:
PostgreSQL Installer Walkthrough
After Installation Follow These Steps:
STEP 1-
C:\Program Files\PostgreSQL\8.2\bin
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres
Password for user postgres:postgres
Welcome to psql 8.2.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.
postgres=#
OR STEP 2- To Set Environment Variables
Click on Start=>Control Panel(Switch to classic user View)=> System
A window will Prompt Then click On " Advanced " button and then select "Environmental Variables"
Set user variables :
Variable name : PATH
Variable Value: C:\Program Files\PostgreSQL\8.2\bin
click on ok and ok and ok .........