Search for column name in psql

select t.table_schema,
       t.table_name
from information_schema.tables t
inner join information_schema.columns c on c.table_name = t.table_name 
                                and c.table_schema = t.table_schema
where c.column_name = 'last_name'
      and t.table_schema not in ('information_schema', 'pg_catalog')
      and t.table_type = 'BASE TABLE'
order by t.table_schema;

Similar codes

0 vote129 views1 answer
Mysql sum per week
SQL
0 vote127 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote109 views1 answer
Mysql date minus 1 day
SQL
13 votes121 views6 answers
Mysql remove duplicates
SQL
0 vote123 views1 answer
Oracle swap partition
SQL
1 vote109 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
2 votes122 views3 answers
Mysql list tables by size
SQL
11 votes112 views4 answers
Query DISTINCT
SQL
0 vote117 views1 answer
Do postgresql
SQL
0 vote148 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL