PostGre Admin 3 : Managing Database

• PostgreSQL database is a open source object relational database.
• Benefits like savings in staffing cost as SQL is known, reliability, stability, cross platform nature,GUI based database management  made it popular.
• Download Link:       http://www.postgresql.org/download/windows/

• After Installation in programs “PgAdmin III” is available.This is the GUI based management for PostgreSQL.

PostGreSQL Admin 3:-

• The admin will looks like,

•   Connect to the default server :-

• After connection it will look like,

• create a database call “StudentDataBase“m

• Set privileges for student database,

• StudentDataBase public schema,

• creating StudentDetail Table in this database,

• Adding two new column name and mark,

• After adding columns,

 

• Inserting Data to this table,

•  View the data by clicking “view the data in selected object“,