SET / RESET
SET and RESET change a setting for the current connection.
Example
Section titled “Example”SET pivot_stats = true;SELECT count(*) FROM system.tables;RESET pivot_stats;Syntax
Section titled “Syntax”SET pivot_stats = true;RESET pivot_stats;Execution statistics
Section titled “Execution statistics”SET pivot_stats = true includes execution statistics with query results.
RESET pivot_stats turns them off.
The setting belongs to the current connection. Server memory, worker counts, and other deployment settings are configured in YAML.
Compatibility
Section titled “Compatibility”These are Pivot settings. PostgreSQL wire compatibility does not make every
PostgreSQL configuration parameter available through SET.