Postgres Pro
Downloads
Home   >   mailing lists

How to get partition info for a partition table? - Mailing list pgsql-general

From Yuxia Qiu
Subject How to get partition info for a partition table?
Date
Msg-id CAJ0a2Rn76cwwoxR=+T3mKvmttOL9DtnCx7N4YePXRXj6NA_pow@mail.gmail.com
Whole thread Raw
Responses Re: How to get partition info for a partition table?
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: RE: GIN Index for low cardinality
Next
From: Thomas Munro
Date:
Subject: Re: Different memory allocation strategy in Postgres 11?