Cacher is the code snippet organizer for pro developers

createuser -U postgres name
createdb -U postgres name

or

sudo -u postgres psql
CREATE USER name WITH PASSWORD 'password';
CREATE DATABASE name;