SELECT
Count(*) AS nr,
Count(*) FILTER (WHERE 'security_barrier=true'=ANY(pg_catalog.pg_class.reloptions) ) AS nr_of_security_barrier_views,
Count(*) FILTER (WHERE (('security_barrier=true'<>ALL(pg_catalog.pg_class.reloptions)) 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 ('security_barrier=true'<>ALL(pg_catalog.pg_class.reloptions)) 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 'security_barrier=true'=ANY(pg_catalog.pg_class.reloptions) ) AS security_barrier_views,
string_agg(nspname || '.' || relname ,',<br>' ORDER BY nspname , relname ) FILTER (WHERE ('security_barrier=true'<>ALL(pg_catalog.pg_class.reloptions)) 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);