I see there are at least other two options for SET/SHOW/RESET commands:
- KSQO
- QUERY_LIMIT
I would to underline the help is not updated about KSQO:
hygea=> \h show
Command: show
Description: show current run-time environment
Syntax: SHOW DateStyle|GEQO|R_PLANS|QUERY_LIMIT
hygea=> \h reset
Command: reset
Description: set run-time environment back to default
Syntax: RESET DateStyle|GEQO|R_PLANS|QUERY_LIMIT
hygea=> \h set
Command: set
Description: set run-time environment
Syntax: SET DateStyle TO
'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'
set GEQO TO 'ON[=#]'|'OFF'
set R_PLANS TO 'ON'| 'OFF'
set QUERY_LIMIT TO #
Jose'