Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get partition info for a partition table? - Mailing list pgsql-general

From legrand legrand
Subject Re: How to get partition info for a partition table?
Date
Msg-id 1540645294115-0.post@n3.nabble.com
Whole thread Raw
In response to How to get partition info for a partition table?  (Yuxia Qiu <yuxiaqiu1@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: GPT
Date:
Subject: Re: rw_redis_fdw: SQL Errors when statement is within a function
Next
From: Adrian Klaver
Date:
Subject: Re: rw_redis_fdw: SQL Errors when statement is within a function