Show version
SHOW SERVER_VERSION;
Show system status
\\conninfo
Show environmental variables
SHOW ALL;
List users
SELECT rolname FROM pg_roles;
Show current user
SELECT current_user;
Show current user's permissions
\\du
Show current database
SELECT current_database();
Show all tables in database
\\dt
List functions
\\df <schema>
Databases