How to see if a column exists in at least some table of the current schema?

Question

PostgreSQL

Hello! I have a schema that has a fairly large number of tables. How can I check that at least one table has the column I need?

Answer 1

select table_name from information_schema.columns where column_name = ? and table_schema = ?;

Or the same through native pg_attribute.

Answer 2

the algorithm is simple: get a list of tables and check each one :)