Different character maximum lengths that are used to define textual base table columns

Copy SQL

WITH lengths AS (SELECT DISTINCT character_maximum_length
FROM INFORMATION_SCHEMA.columns INNER JOIN INFORMATION_SCHEMA.tables USING (table_schema, table_name)
WHERE table_type='BASE TABLE'
AND data_type ILIKE '%char%'
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))
SELECT Count(character_maximum_length) AS number_of_different_char_max_lengths, Count(*) AS number_of_char_varchar_columns, 
string_agg(character_maximum_length::text, ',<br>' ORDER BY character_maximum_length) AS character_maximum_lengths
FROM lengths;