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

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get partition info for a partition table?
Date: 2018-10-27 13:01:34
Message-ID: 1540645294115-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-10-27 13:38:45 Re: rw_redis_fdw: SQL Errors when statement is within a function
Previous Message GPT 2018-10-27 10:57:42 Re: rw_redis_fdw: SQL Errors when statement is within a function