freebsd pgsql

# su pgsql
$psql -U pgsql template1

create user test;
alter user test superuser createrole createdb;
alter user test nosuperuser nocreaterole nocreatedb;
password test

create database test;
create database test owner=test;
\h drop user
drop database test;
\du