getting table name from partition

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: michal(dot)palenik(at)freemap(dot)sk
Subject: getting table name from partition
Date: 2021-07-14 13:45:12
Message-ID: 162627031219.693.11508199541771263335@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/ddl-partitioning.html
Description:

I would like to add a sentence like this into the description of
partitions:

You receive the name of the partition table data is from using
tableoid::regclass as column name in the select.

to tell the option of getting "real" tablename, eg when partitions are based
on locality.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-07-14 18:45:27 ddl-basics.html plural stuff
Previous Message Jack Christensen 2021-07-14 13:11:50 Re: NOT DEFERRABLE constraints are checked before command finishes