Re: How to list partitions of a table in PostgreSQL 10

Use *\d+ tablename *in psql to list all the child tables (partitions).


On Tue, Oct 31, 2017 at 1:00 PM Stephen Froehlich <[email protected]>
wrote:

> I have discovered a simple query that will tell me if a table is a
> registered partition or not, which meets my purposes for now, but a list of
> partitions of a given table would be better:
>
>
>
> SELECT 1 FROM pg_class WHERE relname = '[attached_partition_name_here]'
> AND relpartbound IS NOT NULL;
>
>
>
> --Stephen
>
>
>
> *From:* [email protected] [mailto:
> [email protected]] *On Behalf Of *Stephen Froehlich
> *Sent:* Tuesday, October 31, 2017 1:02 PM
> *To:* [email protected]
> *Subject:* [NOVICE] How to list partitions of a table in PostgreSQL 10
>
>
>
>
> This sender failed our fraud detection checks and may not be who they appear to be. Learn about
> spoofing <http://aka.ms/LearnAboutSpoofing>
>
> Feedback <http://aka.ms/SafetyTipsFeedback>
>
> *CableLabs WARNING:* The sender of this email could not be validated and
> may not match the person in the "From" field.
>
> What is the syntax to get a list of the partitions of a table in
> PostgreSQL 10?
>
>
>
> Thanks,
>
> Stephen
>
>
>
> Stephen Froehlich
> Sr. Strategist, *Cable*Labs®
>
>
> [email protected]
>
> Tel: +1 (303) 661-3708
>
>
>


-- 
Achieve real learning.  Email [email protected].