以下の SQL の 'xxxxx' の部分を列名に変更します。
SELECT schemas.nspname AS schema_name
, tables.relname AS table_name
FROM pg_attribute AS colmuns
INNER JOIN pg_class AS tables
ON colmuns.attrelid = tables.oid
INNER JOIN pg_namespace AS schemas
ON tables.relnamespace = schemas.oid
WHERE colmuns.attname = 'xxxxx'
ORDER BY schema_name, table_name