Copy SQL

WITH columns AS (SELECT table_schema, table_name, table_type || ' COLUMN' AS suspected_object_type, column_name AS suspected_name, data_type
FROM information_schema.columns INNER JOIN information_schema.tables USING (table_schema, table_name)
UNION SELECT nspname, relname, 'MATERIALIZED VIEW COLUMN' AS type, attname, typname
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
INNER JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid INNER JOIN pg_type ON
pg_attribute.atttypid=pg_type.oid
WHERE relkind = 'm' AND attnum>=1)

SELECT translate(suspected_name,'0123456789_','') AS suspected_name, Count(*) AS nr_of_occurrences
FROM columns
WHERE (suspected_name~*'(andme(?!(baas|[_]*tyyp))|(?'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
GROUP BY translate(suspected_name,'0123456789_','')
ORDER BY Count(*) DESC, suspected_name;