Reference: Set/Show Setting Statement
The SHOW, SET, and RESET statements allow you to inspect and change database and session settings.
Usage example:
SHOW TimeZone; timezone
---------------
Europe/Berlin
(1 row)SET timezone='US/Pacific';To restore a setting to its default value, use RESET:
RESET TimeZone;Show all settings
SHOW ALL; name | setting | description
--------------------------------+-----------------------+---------------------------------------------------------
allow_system_table_mods | off | Allows modifications of the structure of system tables.
...
default_transaction_isolation | repeatable read | Sets the transaction isolation level of each new transaction.
...
timezone | Europe/Berlin | Sets the time zone for displaying and interpreting time stamps.
...
(n rows)For compatibility with existing PostgreSQL clients, CedarDB accepts many settings that are currently silently ignored.
