Size of schema

PL/pgSQL

select pg_size_pretty(CAST((SELECT
SUM(pg_total_relation_size(table_schema || '.' || table_name) )
FROM information_schema.tables
WHERE table_schema = 'SCHEMA NAME HERE') As bigint) )  As tables_schema_size;