Contador de tablas por esquema en PostgreSQL

table_count_by_schema_pg.sql

SELECT
	count(*) AS "tables", schemaname
FROM
	pg_tables
WHERE
	schemaname 
IN
    (
        SELECT
			    nspname
		    FROM
			    pg_catalog.pg_namespace
		    WHERE
    		  nspname
		    NOT IN(
			    'pg_toast',
    		  'pg_temp_1',
    		  'pg_toast_temp_1',
    		  'pg_catalog',
    		  'information_schema',
    		  'shared_extensions'
		    )
    )
GROUP BY
	schemaname