在 PgAdmin 中的所有表中搜索

SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'public'
AND data_type IN ('character varying', 'text', 'character', 'varchar')
AND EXISTS (
    SELECT 1 FROM information_schema.tables
    WHERE table_name = information_schema.columns.table_name
    AND table_schema = information_schema.columns.table_schema
    AND (SELECT COUNT(*) FROM information_schema.columns
         WHERE table_name = information_schema.tables.table_name
         AND table_schema = information_schema.tables.table_schema
         AND data_type IN ('character varying', 'text', 'character', 'varchar')) > 0
);