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