Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5594~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5594
Choose a head ref
  • 2 commits
  • 7 files changed
  • 2 contributors

Commits on Jan 2, 2026

  1. psql: Listing "not-partition" tables and indexes 

    This patch introduces the new letter N for the \d (describe)
metacommand of psql. Using this command, one can take a look at
the high-level table (resp. index) structure, meaning those that
are NOT (thus, "N") a partition of any other table (resp. index).

This is useful when the database has many (tens or hundreds) of
partitioned tables. Simply issuing \d (or \dt or \di) will list so
many objects, and getting a high-level peek at the database design
becomes hard.

Using the new \dN, \dtN (= \dNt) or \diN (= \dNi), one can more
easily observe the high-level design of the tables and indexes.

For instance, if the database has two tables t and u, and these
are further partitioned as follows:

t
+-- t0
+-- t1
+-- t2

u
t
+-- u0
+-- u1

Then issuing \dtN will only list t and u, which is close to the
"logical" database design, and spares the further "physical" design,
where partitions t0, t1, t2, u0, and u1 would also be listed.
    @msdousti
    msdousti authored and Commitfest Bot committed Jan 2, 2026
    Configuration menu
    Copy the full SHA
    f8bbad1 View commit details
    Browse the repository at this point in the history

  2. [CF 5594] v8 - psql \dN[ti]: Describe tables and indexes that are NO … 

    …partitions of others

This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5594

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/CADE6LvhCgu9B1e5D2NMnM3L4P89pUdDEAUUCtZ58OWLnnELmZw@mail.gmail.com
Author(s): Sadeq Dousti
    Commitfest Bot committed Jan 2, 2026
    Configuration menu
    Copy the full SHA
    b55bb87 View commit details
    Browse the repository at this point in the history
Loading