sql - 如何检查我所有表的存在？在 postgresql 中

Question

我想检查我所有的表是否存在。如果所有表都存在则发送 1，如果缺少一张或多张表则发送 0。

select 1 from information_schema.tables tbl where tbl.table_name='graphe';
select 1 from information_schema.tables tbl where tbl.table_name='proprieteindicateur';
select 1 from information_schema.tables tbl where tbl.table_name='graphe_proprieteindicateur';
select 1 from information_schema.tables tbl where tbl.table_name='utilisateurs';
select 1 from information_schema.tables tbl where tbl.table_name='profil';
select 1 from information_schema.tables tbl where tbl.table_name='droit'; 

Answer 1

这可以用一条语句完成:

with table_list (name) as (
  values 
   ('graphe'),
   ('proprieteindicateur'),
   ('graphe_proprieteindicateur'),
   ('utilisateurs'),
   ('profil'),
   ('droit')
)
select count(*) = (select count(*) from table_list)
from information_schema.tables it
  join table_list l on it.table_name = l.name
and it.table_schema = 'public';

如果所有表都被找到，返回true，否则返回false。