you can view the postgres database by an external application called pgadminIII

here you can connect it with your database system

http://suite.opengeo.org/4.1/dataadmin/pgGettingStarted/pgadmin.html

this application is used to view databases in postgres

INSTALL PG ADMIN- from ubuntu software centre

CONNECTING PG ADMIN TO POSTGRES

this will be screen on openng pgadmin

click on the first link to connect to localhost

then you will get the below screen

fill the form

name: name for this connection(localhost)

host: localhost

port: 5432

service: leave blank

Maintenance DB: select postgres

username: postgres username(postgres)

password: postgres user password( you can change the password of postgres via terminal in psql)

click on the connect button