schema_table_row_counts.sql

--- PostgreSQL: Row Count for All Tables in a Schema
DO $$
DECLARE
    r RECORD;
    cnt BIGINT;
BEGIN
    FOR r IN
        SELECT tablename
        FROM pg_tables
        WHERE schemaname = 'table_name'
    LOOP
        EXECUTE format('SELECT count(*) FROM table_name.%I', r.tablename)
        INTO cnt;

        RAISE NOTICE '%: % rows', r.tablename, cnt;
    END LOOP;
END $$;