postgres=# SELECT * FROM pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | userepl | passwd | valuntil | useconfig ----------+----------+-------------+----------+-----------+---------+-------------------------------------+----------+----------- postgres | 10 | t | t | t | t | | | wechat | 16385 | f | f | f | f | md55bf335eef50073dbc3a4a2103e7b3757 | | test | 16387 | f | f | f | f | md505a671c66aefea124cc08b76ea6d30bb | | dba | 16384 | t | t | t | f | md5a1453e5a69943d1674eb2f7100efa04c | | (4 rows)