Horton
Menu

Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Bharani SV-forum <esteembsv-forum@yahoo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2024-11-15T19:56:54Z
Lists: pgsql-general 
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.