Creating a sample database

Creating a sample database

install postgresql

sudo apt-get install postgresql

create a sample database

sudo su postgresql
psql
CREATE USER agh WITH PASSWORD 'AGH-salaries';
CREATE DATABASE salaries OWNER agh; 
GRANT ALL PRIVILEGES ON DATABASE "salaries" to agh;