WITH boolean_columns AS (SELECT table_schema, table_name, column_name
FROM INFORMATION_SCHEMA.columns
WHERE data_type='boolean' AND 
(table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') AND 
table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)),
nr_of_boolean_columns_is_1 AS (SELECT table_schema, table_name
FROM boolean_columns
GROUP BY table_schema, table_name
HAVING Count(*)=1)
SELECT table_schema, table_name, column_name
FROM boolean_columns
WHERE (table_schema, table_name) IN (SELECT 
table_schema, table_name
FROM nr_of_boolean_columns_is_1) 
AND column_name~*'(aktiivne|aktuaalne|active)'
ORDER BY table_schema, table_name;