johnp@sussancws0114:~/downloads$ /opt/PostgreSQL/8.4/bin/psql -U postgres
Password for user postgres:
psql (8.4.14)
Type "help" for help.
Cannot read termcap database;
using dumb terminal settings.
postgres=# drop user johnp;
DROP ROLE
postgres=# create user bruno password 'hello';
CREATE ROLE
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+-------------+-----------
bruno | | {}
postgres | Superuser | {}
: Create role
: Create DB
postgres=# \q
johnp@sussancws0114:~/downloads$ /opt/PostgreSQL/8.4/bin/psql -U bruno
Password for user bruno:
psql: FATAL: database "bruno" does not exist
johnp@sussancws0114:~/downloads$