Encuentra la columna ‘TAL’ entre todas las tablas

select c.relname
from pg_class as c
inner join pg_attribute as a on a.attrelid = c.oid
where a.attname = ‘nombre_de_columna’ and c.relkind = ‘r’