SELECT
Count(*) AS nr_of_views,
Count(*) FILTER (WHERE (pg_catalog.pg_class.reloptions::text~*'security_barrier=(true|on|1)')) AS nr_of_security_barrier_views,
Count(*) FILTER (WHERE ((pg_catalog.pg_class.reloptions::text!~*'security_barrier=(true|on|1)'
OR pg_catalog.pg_class.reloptions IS NULL) AND pg_get_viewdef(pg_class.oid)~*'WHERE[[:space:]]')) AS nr_of_non_security_barrier_views_with_where,
Count(*) FILTER (WHERE (pg_catalog.pg_class.reloptions::text!~*'security_barrier=(true|on|1)'
OR pg_catalog.pg_class.reloptions IS NULL)) AS nr_of_non_security_barrier_views,
string_agg(nspname || '.' || relname ,',<br>' ORDER BY nspname , relname ) FILTER (WHERE (pg_catalog.pg_class.reloptions::text~*'security_barrier=(true|on|1)')) AS security_barrier_views,
string_agg(nspname || '.' || relname ,',<br>' ORDER BY nspname , relname ) FILTER (WHERE (pg_catalog.pg_class.reloptions::text!~*'security_barrier=(true|on|1)'
OR pg_catalog.pg_class.reloptions IS NULL)) AS non_security_barrier_views
FROM
pg_catalog.pg_class,
pg_catalog.pg_namespace
WHERE pg_catalog.pg_class.relnamespace=pg_catalog.pg_namespace.oid
AND relkind='v'
AND nspname NOT IN (SELECT schema_name
FROM information_schema.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL);