Find all columns by name

Find all tables and views by a column name:

SELECT c.table_schema,
       c.table_name,
       c.column_name,
       t.table_type
FROM information_schema.columns c
JOIN information_schema.tables t
     ON c.table_schema = t.table_schema
    AND c.table_name = t.table_name
WHERE c.column_name = '<column_name>'
ORDER BY c.table_schema, c.table_name;

Results:

 table_schema |     table_name     | column_name | table_type
--------------+--------------------+-------------+------------
 public       | users              | name        | BASE TABLE
 public       | products           | name        | VIEW