PostgreSQL Obtener tablas de un schema

SELECT 
    t1.TABLE_NAME AS tabla_nombre,
    PG_CATALOG.OBJ_DESCRIPTION(t2.OID, 'pg_class') AS tabla_descripcion
FROM 
    INFORMATION_SCHEMA.TABLES t1
    INNER JOIN PG_CLASS t2 ON (t2.relname = t1.table_name)
WHERE 
    t1.TABLE_SCHEMA='public'
ORDER BY
    t1.TABLE_NAME;