Thread: Modify SHOW to display reloptions by accepting table-qualified names.
Modify SHOW to display reloptions by accepting table-qualified names.
From
"David G. Johnston"
Date:
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. It is mostly redundant with \d+ which already distinguishes unset and set options by displaying the later, but being SQL and more explicit seems to at least make considering extending SHOW worthwhile. An unset reloption specified here could then have its computed value displayed and annotated.
David J.
"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