Postgres Pro
Downloads
Home   >   mailing lists

Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) - Mailing list pgsql-general

From David G. Johnston
Subject Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)
Date
Msg-id CAKFQuwaPQBeFa==VJLYFYUh5V514Y4ZE9O0bz+kmLjgowLm9kQ@mail.gmail.com
Whole thread Raw
In response to Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)  (Bharani SV-forum <esteembsv-forum@yahoo.com>)
List pgsql-general
Tree view
On Fri, Nov 15, 2024 at 12:46 PM Bharani SV-forum <esteembsv-forum@yahoo.com> wrote:
Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)


The premise that a detached table is distinguishable from any other table that is not a partition is an interesting one that I wouldn't necessarily expect to be determinable.  You could probably write a query listing tables that are candidates for attaching to an existing partitioned table and then filter out those that are actually attached.

David J.

pgsql-general by date:

Previous
From: Bharani SV-forum
Date:
Subject: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)
Next
From: Adrian Klaver
Date:
Subject: Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)