// Personal website of Chris Smith

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;