|Creating New DB|
|Using pgAdminIII application:
|Creating DB pgedemo1 in window 7 pro: click on New Database
Creating a New Role: as manas237
set password: postgre_manas9
login: role is created
Name and Owner name
Definition : Encoding and Table space
Database pgsdemo1 created
Open phpPgAdmin, If you don't have phpPgAdmin, and referesh the new DB will be shown up
|Now let us populate the database "pgsdemo1' with tables.
Open up SQL pane, and make sure that you are connected to "pgsdemo1"
Add source code text in the pane and compile it.
Compiled as expected
-- Database: pgsdemo1
View with phpPgAdmin
Query :"select * from emp:
Testing using php