count_rows.sql

-- Count the number of rows for all tables in a schema
-- From: https://stackoverflow.com/a/38684225/638425

select table_schema, 
       table_name, 
       (xpath('/row/cnt/text()', xml_count))[1]::text::bigint as row_count
from (
  select table_name, table_schema, 
         query_to_xml(format('select count(*) as cnt from %I.%I', table_schema, table_name), false, true, '') as xml_count
  from information_schema.tables
  where table_schema = 'public' --<< change here for the schema you want
) t;