Обсуждение: How to get partition info for a partition table?
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
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