SHOW ALL is a projection over pg_catalog.pg_settings, so it covers every setting the engine defines: the public ones, meaning the settings Firebolt documents, supports, and keeps stable, and the internal ones, whose names and defaults change between releases. Query pg_catalog.pg_settings directly for the remaining columns, such as the default value and the setting type, or query information_schema.settings for the same columns over the public settings only. For the other views in these schemas, see Information schema. For the meaning of individual settings and how to change them, see System settings.
Syntax
SHOW ALL takes no arguments.
Returns
The returned table has the following columns.Example
The output above is truncated;
SHOW ALL returns every setting. To list only the public ones, query information_schema.settings.