怎么查找某字段在数据库中的哪个表

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 = '模式';