Perhaps the type of a base table column should be XML, JSON, or JSONB (based on column names)

Copy SQL

SELECT table_schema, table_name, column_name, data_type, character_maximum_length 
FROM INFORMATION_SCHEMA.columns
WHERE column_name !~* 'name'
AND (character_maximum_length IS NULL
OR character_maximum_length>=1000)
AND ((column_name ~* 'xml' 
AND  data_type<>'xml') 
OR (column_name ~* 'json' 
AND  data_type NOT IN ('json','jsonb'))) 
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)
ORDER BY table_schema, table_name, ordinal_position;