Re: psql \dh: List High-Level (Root) Tables and Indexes

vignesh C <vignesh21@gmail.com>

From: vignesh C <vignesh21@gmail.com>

To: Sadeq Dousti <msdousti@gmail.com>

Cc: Greg Sabino Mullane <htamfids@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston" <david.g.johnston@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-02-27T05:43:59Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql \dP: list partitioned tables and indexes
- 1c5d9270e339 12.0 cited

On Wed, 26 Feb 2025 at 23:21, Sadeq Dousti <msdousti@gmail.com> wrote:
>
> Thanks a lot Greg!
>
> > Changes look good to me, thanks. Can you make a new patch that applies a single set of changes to HEAD?
>
> Please find attached the diff to Head in a single file.

Currently we are supporting only PG13 and higher versions. I'm not
sure if we should support lesser than PG15 version:
+       /*
+        * Note: Declarative table partitioning is only supported as of Pg 10.0.
+        */
+       if (showNoPartitions && pset.sversion < 100000)
+       {
+               char            sverbuf[32];
+
+               pg_log_error("The server (version %s) does not support
declarative table partitioning.",
+
formatPGVersionNumber(pset.sversion, false,
+
            sverbuf, sizeof(sverbuf)));
+               return true;
+       }

Regards,
Vignesh