postgresql - first look - ubuntu

• at first you should install postgresql 

sudo apt-get install postgresql-9.3

• then create your first user and database

**sudo -u postgres createuser -D -A -P testuser **

sudo -u postgres createdb -O testuser testdb

• then install gui for watching your db entries

sudo apt-get install pgadmin3

• open pgadmin and click add to new server, you should give your db username and password. 

• now you can find your tables under : databases -> testdb -> schemas -> public -> tables