postgresql - first look - ubuntu

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