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

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: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Stephen Froehlich
Sent: Tuesday, October 31, 2017 1:02 PM
To: pgsql-novice(at)postgresql(dot)org
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, CableLabs(r)

s(dot)froehlich(at)cablelabs(dot)com<mailto:s(dot)froehlich(at)cablelabs(dot)com>
Tel: +1 (303) 661-3708