PostgreSQL client

1 连接

$ psql postgres://username:password@host:port/dbname  
$ psql -U username -h hostname -p port -d dbname 
psql (9.2.24, server 16.6)
WARNING: psql version 9.2, server version 16.0.
         Some psql features might not work.
Type "help" for help.

postgres=#

2 查询用户

 > \du
 or
 > SELECT * FROM pg_shadow;