PostgreSQL » Adding a new user and database
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;