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> 
Comments