psql=# create user bork with password 'bork'; You can also do this for a passwordless user: % crateuser bork
psql=# create user bork with password 'bork';
You can also do this for a passwordless user: % crateuser bork
% crateuser bork