Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version


PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit


SELECT 1

create table table_1 (col int);
CREATE TABLE

create table table_2 (col int);
CREATE TABLE

create table table_3 (col int);
CREATE TABLE

create table table_4 (col int);
CREATE TABLE

create table table_5 (col int);
CREATE TABLE

create table tablea (tablename varchar(100));
CREATE TABLE

insert into tablea values ('TABLE_3'), ('TABLE_4');
INSERT 0 2

select 'TABLE_1', count(*) from table_1 having 'TABLE_1' in (select tablename from tablea)
union all
select 'TABLE_2', count(*) from table_2 having  'TABLE_2' in (select tablename from tablea)
union all
select 'TABLE_3', count(*) from table_3 having 'TABLE_3' in (select tablename from tablea)
union all
select 'TABLE_4', count(*) from table_4 having 'TABLE_4' in (select tablename from tablea)
union all
select 'TABLE_5', count(*) from table_5 having 'TABLE_5' in (select tablename from tablea);


?column?
count


TABLE_3
0

TABLE_4
0


SELECT 2