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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Bharani SV-forum <esteembsv-forum(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)
Date: 2024-11-15 19:56:54
Message-ID: CAKFQuwaPQBeFa==VJLYFYUh5V514Y4ZE9O0bz+kmLjgowLm9kQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 15, 2024 at 12:46 PM Bharani SV-forum <esteembsv-forum(at)yahoo(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-11-15 21:13:30 Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)
Previous Message Bharani SV-forum 2024-11-15 19:46:18 Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)