Getting the number of records in all tables in PostgreSQL (use count)

pg_get_table_count.sql

WITH tbl AS (
    SELECT table_schema, table_name 
    FROM information_schema.tables
    WHERE table_name NOT LIKE 'pg_%' AND table_schema NOT IN ('information_schema')
)
SELECT table_schema, table_name,
    (xpath('/row/c/text()', query_to_xml(format('SELECT count(1) AS c FROM "%I"."%I"', table_schema, table_name), FALSE, TRUE, '')))[1]::text::bigint AS table_count
FROM tbl;