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
