PostgreSQL: Creating a new user and database

postgresql-new-user.sql

-- Create the database user
CREATE USER rponte WITH PASSWORD '123';

-- Create the database
CREATE DATABASE mydb WITH  OWNER      = rponte 
                           ENCODING   = 'UTF8' 
                           LC_CTYPE   = 'en_US.UTF-8' 
                           LC_COLLATE = 'en_US.UTF-8'
                           TEMPLATE   = template0;

-- Grant permissions for the created user
GRANT ALL PRIVILEGES ON DATABASE mydb TO rponte;