Query to identify the orphan tables

 

 /*Query to identify the orphan tables*/
———————————————————————————————————–
select pgns.nspname as schema_name
, pgc.relname as object_name
from pg_class pgc
join pg_namespace pgns on pgc.relnamespace = pgns.oid
where pg_is_other_temp_schema(pgc.relnamespace);