SHOW DEFAULT SESSION VARIABLES FOR ROLE

SHOW DEFAULT SESSION VARIABLES FOR ROLE public;

SHOW DEFAULT SESSION VARIABLES FOR ROLE 0

SELECT * FROM [SHOW DEFAULT SESSION VARIABLES FOR ROLE public];

  session_variables | default_values | database | inherited_globally
--------------------+----------------+----------+---------------------
(0 rows)

CREATE USER movr_auditor;

ALTER ROLE ALL SET application_name = 'movr';

SHOW DEFAULT SESSION VARIABLES FOR ROLE movr_auditor;

  session_variables | default_values | database | inherited_globally
--------------------+----------------+----------+---------------------
  application_name  | movr           | NULL     |         t
(1 row)

CREATE DATABASE movr_audit;

ALTER ROLE ALL IN DATABASE movr_audit SET application_name = 'movr_audit';

SHOW DEFAULT SESSION VARIABLES FOR ROLE movr_auditor;

  session_variables | default_values |  database  | inherited_globally
--------------------+----------------+------------+---------------------
  application_name  | movr_audit     | movr_audit |         t
  application_name  | movr           | NULL       |         t
(2 rows)

SHOW DEFAULT SESSION VARIABLES FOR ROLE ALL;

  session_variables | default_values |  database
--------------------+----------------+-------------
  application_name  | movr_audit     | movr_audit
  application_name  | movr           | NULL
(2 rows)

\h SHOW DEFAULT SESSION VARIABLES FOR ROLE

Command:     SHOW DEFAULT SESSION VARIABLES FOR ROLE
Description: list default session variables for role
Category:    privileges and security
Syntax:
SHOW DEFAULT SESSION VARIABLES FOR ROLE <name>