Get Row Counts for Each Table in PostgreSQL Database

get_row_counts_postgres.sql

CREATE FUNCTION pg_temp.get_rows(p_schemaname text, p_tablename text)
RETURNS bigint AS $$
DECLARE
    result_rowcount bigint;
BEGIN
    EXECUTE format('SELECT COUNT(*) FROM "%I"."%I"', p_schemaname, p_tablename)
    INTO result_rowcount;
    RETURN result_rowcount;
END;
$$ LANGUAGE plpgsql;

SELECT
    schemaname AS schemaname,
    tablename AS table_name,
    pg_temp.get_rows(schemaname, tablename) AS cnt
FROM
    pg_tables
WHERE
    schemaname in  ('person','sales','purchasing','production','humanresources');