Modify SHOW to display reloptions by accepting table-qualified names.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Modify SHOW to display reloptions by accepting table-qualified names.
Date: 2025-03-24 15:45:36
Message-ID: CAKFQuwZ4m62GULq0C4F7eXP_FE6L4Q3tc+EMLTR1o4KVjCxHkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2025-03-24 15:47:31 Re: Restrict publishing of partitioned table with a foreign table as partition
Previous Message Nikolay Shaplov 2025-03-24 15:45:00 Re: vacuum_truncate configuration parameter and isset_offset