Creating New DB

database tables: scott_pgsql_employee.txt
Using pgAdminIII application:

Using phpPgAdmin
 
Creating DB pgedemo1 in window 7 pro: click on New Database

Creating a New Role: as manas237

set password: postgre_manas9

Role: privilege:

login: role is created

 

Name and Owner name

Definition : Encoding and Table space

Privilege

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

-- DROP DATABASE pgsdemo1;

CREATE DATABASE pgsdemo1
WITH OWNER = manas237
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'English_United States.1252'
LC_CTYPE = 'English_United States.1252'
CONNECTION LIMIT = -1;

Link : complete code: scott_pgsql_employee.txt

View with phpPgAdmin

Query :"select * from emp:

Testing using php