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 vote201 views1 answer
Full syntax inner join
SQL
1 vote225 views1 answer
Mysql search like order by best match
SQL
1 vote205 views1 answer
Sql try catch
SQL
0 vote206 views1 answer
Recursive query herarchical data sql server
SQL
1 vote223 views2 answers
Oracle 18c xe ORA-65096
SQL
11 votes226 views1 answer
Oracle view source
SQL
0 vote231 views1 answer
Sql select where more than one record exists
SQL
2 votes230 views2 answers
Postgres trigger insert into another table
SQL
8 votes237 views3 answers
Postgres database sizes
SQL
0 vote213 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL