Re: [NOVICE] 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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Stephen Froehlich
Sent: Tuesday, October 31, 2017 1:02 PM
To: pgsql-novice@postgresql.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

Feedback

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^®

s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708