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