Date: Fri, 15 Nov 2024 19:46:18 +0000 (UTC)
From: Bharani SV-forum <esteembsv-forum@yahoo.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Message-ID: <98965993.3138805.1731699978332@mail.yahoo.com>
In-Reply-To: <A01D7215-2691-4FA6-8B79-E197B7DB9351@gmail.com>
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <A01D7215-2691-4FA6-8B79-E197B7DB9351@gmail.com>
Subject: Need exact SQL query to find List of Detach Partitioned Tables (Yet
 to be Dropped)
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3138804_1088609385.1731699978331"
Content-Length: 2699
Archived-At: <https://www.postgresql.org/message-id/98965993.3138805.1731699978332%40mail.yahoo.com>
Precedence: bulk

------=_Part_3138804_1088609385.1731699978331
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

=C2=A0Team
Need exact SQL query to find List of Detach Partitioned Tables (Yet to be D=
ropped)
The following is the query which i used, i am using and i found an bug whic=
h is listing an newly created table (last week)
SELECT relnamespace::regnamespace::text AS schema_name, relname AS table_na=
me
FROM=C2=A0=C2=A0 pg_class c
WHERE=C2=A0 NOT relispartition=C2=A0 -- !
AND=C2=A0=C2=A0=C2=A0 relkind =3D 'r' and lower(relnamespace::regnamespace:=
:text) not in ('pg_catalog','partman','information_schema')=C2=A0 and
lower(relnamespace::regnamespace::text) in ('XYZ')=20
order by=C2=A0 relnamespace::regnamespace::text, relname ;
------=_Part_3138804_1088609385.1731699978331
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpc1b59bb1yahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px=
;" dir=3D"ltr" data-setdir=3D"false"><div></div>&nbsp;Team</div><div class=
=3D"ydpc1b59bb1yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Helve=
tica, Arial, sans-serif;font-size:16px;" dir=3D"ltr" data-setdir=3D"false">=
<br></div><div class=3D"ydpc1b59bb1yahoo-style-wrap" style=3D"font-family:H=
elvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;" dir=3D"ltr" da=
ta-setdir=3D"false"><span>Need exact SQL query to find List of Detach Parti=
tioned Tables (Yet to be Dropped)</span></div><div class=3D"ydpc1b59bb1yaho=
o-style-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-s=
erif;font-size:16px;" dir=3D"ltr" data-setdir=3D"false"><br></div><div clas=
s=3D"ydpc1b59bb1yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Helv=
etica, Arial, sans-serif;font-size:16px;" dir=3D"ltr" data-setdir=3D"false"=
>The following is the query which i used, i am using and i found an bug whi=
ch is listing an newly created table (last week)</div><div class=3D"ydpc1b5=
9bb1yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Arial=
, sans-serif;font-size:16px;" dir=3D"ltr" data-setdir=3D"false"><br><div>SE=
LECT relnamespace::regnamespace::text AS schema_name, relname AS table_name=
<br>FROM&nbsp;&nbsp; pg_class c<br>WHERE&nbsp; NOT relispartition&nbsp; -- =
!<br>AND&nbsp;&nbsp;&nbsp; relkind =3D 'r' and lower(relnamespace::regnames=
pace::text) not in ('pg_catalog','partman','information_schema')&nbsp; and<=
br>lower(relnamespace::regnamespace::text) in ('XYZ') <br>order by&nbsp; re=
lnamespace::regnamespace::text, relname ;</div></div></body></html>
------=_Part_3138804_1088609385.1731699978331--