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

Reply via email to