WITH columns AS (SELECT c.table_schema, c.table_name, regexp_replace(c.column_name, '[[:digit:]]','') AS repeating_column,
c.data_type ||  CASE WHEN c.character_maximum_length IS NOT NULL THEN '(' || c.character_maximum_length::text || ')'
WHEN c.numeric_precision ||'.'|| c.numeric_scale IS NOT NULL THEN '(' || c.numeric_precision ||'.'|| c.numeric_scale || ')'
ELSE '' END AS type, c.column_name, c.ordinal_position
FROM INFORMATION_SCHEMA.columns AS c INNER JOIN INFORMATION_SCHEMA.tables AS t
USING (table_schema, table_name)
WHERE t.table_type='BASE TABLE' AND 
c.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)
AND table_name~* '(attribute|property|properties|atribuu|omadus)' ),
col_values AS (SELECT table_schema, table_name
FROM columns
WHERE column_name~*'(value|vaartus|väärtus)')
SELECT table_schema, table_name, string_agg(column_name || ' ' || type, ';
' ORDER BY ordinal_position) AS columns
FROM columns
WHERE (table_schema, table_name) IN (SELECT table_schema, table_name
FROM col_values)
GROUP BY table_schema, table_name
ORDER BY table_schema, table_name;