| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | [doc] improve tableoid description |
| Date: | 2020-10-17 13:04:38 |
| Message-ID: | CAB8KJ=gFmBXP=P9htziOj+WM5PDAK4qc7iGQta+8kUh306kQnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
[doc] improve tableoid description
Hi
Attached patch aims to improve the description of the tableoid system column [1]
by:
- mentioning it's useful for determining table names for partitioned tables as
well as for those in inheritance hierarchies
- mentioning the possibility of casting tableoid to regclass (which is simpler
than the currently suggested join on pg_class, which is only needed if
the schema name is absolutely required)
[1] https://www.postgresql.org/docs/current/ddl-system-columns.html
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| doc-tableoid-regclass.v1.patch | text/x-patch | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Westermann (DWE) | 2020-10-17 13:50:26 | Re: Wrong example in the bloom documentation |
| Previous Message | Noah Misch | 2020-10-17 11:53:06 | Timing of relcache inval at parallel worker init |