Bare minimum commands for setting up postgres DB using psql

psql_roles.sh

# All commands below are run within psql
psql

# List all roles
\du

# List all Databases
\list
 
# Adding a role 'august' with superuser privaleges
# list of all privaleges here: http://www.postgresql.org/docs/8.1/static/sql-createrole.html
CREATE ROLE august WITH SUPERUSER;
 
# Deleting a role
DROP ROLE august;