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