Can a list of postgresql roles be generated that includes the role's timezone?
I've learned, and tested, that a psql session will take on the timezone of the role used at login. Of course we can alter a role to a particular time zone with:
# ALTER ROLE testUser SET timezone TO 'America/Chicago';
But exactly how can that information be accessed to produce a list so that all the roles can be checked? I've tried \du+, but that returns very limited information. Surprisingly (to me anyway) the information_schema doesn't seem to include the timezone values. Internet searches have so far not helped in this quest.
Where else can I try?