How to get partition info for a partition table?

[Yuxia Qiu <yuxiaqiu1@xxxxxxxxx>]

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