Horton

Re: DOCS - "\d mytable" also shows any publications that publish mytable

Chao Li <li.evan.chao@gmail.com>

View thread
From: Chao Li <li.evan.chao@gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-12-23T08:28:18Z
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 →

  1. doc: Clarify that \d and \d+ output lists are illustrative, not exhaustive.


> On Dec 23, 2025, at 05:07, Peter Smith <smithpb2250@gmail.com> wrote:
> 
> I was looking at "\d" documentation yesterday.
> 
> The psql table describe (e.g. "\d mytable") will display a list of any
> "Publications:" that are publishing the specified table. Somehow, this
> ability had escaped being mentioned in the psql reference
> documentation.
> 
> Here is a trivial patch to fix that omission.
> 
> ======
> Kind Regards,
> Peter Smith.
> Fujitsu Australia
> <v1-0001-DOCS-psql-describe-table-can-list-publications.patch>

Not only publication, “\d table_name” also shows partition information:

```
evantest=# \d t_part;
         Partitioned table "public.t_part"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 id     | integer |           |          |
 val    | integer |           |          |
Partition key: RANGE (id)
Publications:
    "mypub"
Number of partitions: 3 (Use \d+ to list them.)

evantest=# \d t_part_p1;
             Table "public.t_part_p1"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 id     | integer |           |          |
 val    | integer |           |          |
Partition of: t_part FOR VALUES FROM (0) TO (100)
```

As you updating this section, you may add “partition info” as well.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/