CODE EXAMPLE FOR JAVA

java

CREATE ROLE {db_use_name} WITH
  LOGIN
  NOSUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION
  ENCRYPTED PASSWORD 'md5{md5_encrypted_password}';