postgres=# create user pgtest with password 'password12345';
postgres=# select rolpassword from pg_authid where rolname='pgtest';