create role in psql with password

CREATE ROLE username WITH LOGIN PASSWORD 'password';