"David G. Johnston" <david.g.johnston@gmail.com> writes:
> In discussing vacuum_truncate_set it occurs to me there is no SQL way for
> someone to easily view the current setting (or unset status) of a
> reloption. Seems like we could modify SHOW to cover this use case.
That seems like a pretty awful idea; for starters, there is nothing
preventing overlap between the set of GUC names and the set of
table names.
Perhaps it is worth inventing bespoke syntax for this --- I doubt it,
but others might think differently --- but please let's not overload
SHOW.
regards, tom lane