Robert Haas wrote:
> On Mon, Jul 10, 2017 at 2:15 AM, Amit Langote
> <Langote_Amit_f8@lab.ntt.co.jp> wrote:
> > Actually, if \d had shown RELKIND_PARTITIONED_TABLE tables as of Type
> > "partitioned table", we wouldn't need a separate flag for marking a table
> > as having partitions.
>
> I think that is false. Whether something is partitioned and whether
> it is a partition are independent concerns.
Maybe this discussion is easier if we differentiate "list tables" (\dt,
or \d without a pattern) from "describe table" (\d with a name pattern).
It seems to me that the "describe" command should list partitions --
perhaps only when the + flag is given. However, the "list tables"
command \dt should definitely IMO not list partitions. Maybe \dt should
have some flag indicating whether each table is partitioned.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services