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
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*