#!/bin/bash

username=ignacio
password=ignacio
dbname=AAA

create_db="'CREATE DATABASE \"$dbname\";'"

grant_all_privileges="'GRANT ALL PRIVILEGES ON DATABASE \"${dbname}\" TO ${username};'"

create_user="'CREATE USER ${username} WITH PASSWORD '\''${password}'\'';'"


sudo su postgres -c "psql -c $create_db"

sudo su postgres -c "psql -c $create_user"

sudo su postgres -c "psql -c $grant_all_privileges"