Zapytanie o liste table w danym schemacie

select
  table_name,
  table_schema as cnt
from information_schema.columns
where
  table_schema = 'public'
group by
  table_schema,
  table_name