MySQL:
SELECT table_name FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name = '你要查找的字段名';
psql:
SELECT c.relname AS table_nameFROM pg_attribute aJOIN pg_class c ON a.attrelid = c.oidJOIN pg_namespace n ON c.relnamespace = n.oidWHERE a.attname = '你要查找的字段名' AND n.nspname = '模式';