Reference: Set/Show Setting Statement

The set and show statements allow you to inspect and change database and session settings.

Usage example:

show TimeZone;

   timezone    
---------------
 Europe/Berlin
(1 row)

set timezone='US/Pacific';

SET 0

Show all settings

show all;