How to get partition info for a partition table?

From: Yuxia Qiu <yuxiaqiu1(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to get partition info for a partition table?
Date: 2018-10-26 17:37:59
Message-ID: CAJ0a2Rn76cwwoxR=+T3mKvmttOL9DtnCx7N4YePXRXj6NA_pow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI Dear PostgreSQL,

I am pretty new for this DB.
I have created two partition tables as bellow:
*CREATE TABLE* measurement_year_month (
logdate date not null,
peaktemp int,
unitsales int
) PARTITION BY RANGE (EXTRACT(YEAR FROM logdate), EXTRACT(MONTH FROM
logdate));

*create table* partitionTest(
firstname varchar[20],
lastName varchar[20],
id int
)
partition by range (id, firstname);

*My question is:* how do I retrieve the information like bellow?
*Table name* *Partition type * * Partition
information*
measurement_year_month Range (EXTRACT(YEAR FROM
logdate), EXTRACT(MONTH FROM logdate)
partitionTest Range (id,
firstname)

Thanks in advance.

Regards,
Yuxia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2018-10-26 20:13:26 Re: Different memory allocation strategy in Postgres 11?
Previous Message Igor Neyman 2018-10-26 17:21:49 RE: GIN Index for low cardinality