Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to get partition info for a partition table?

How to get partition info for a partition table?

From
Yuxia Qiu
Date:
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

Re: How to get partition info for a partition table?

From
legrand legrand
Date:
see
https://www.postgresql.org/docs/9.5/static/app-psql.html
for psql options an commands:

psql -d ... -U ...
\d+ measurement_year_month

...
Partition key: RANGE (date_part('year'::text, logdate),
date_part('month'::text, logdate))
Number of partitions: 0


if you want to know how postgresql is retrieving those informations
try -E option for ECHO_HIDDEN

psql -d ... -U ... -E
\d+ measurement_year_month



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html