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

1 vote334 views1 answer
Date_part mysql
SQL
10 votes351 views2 answers
Tsql merge example
SQL
27 votes334 views6 answers
Sql update record
SQL
10 votes362 views4 answers
Mysql if else
SQL
2 votes336 views4 answers
2nd highest salary in mysql
SQL
0 vote345 views1 answer
Create a sql server database programmatically
SQL
0 vote378 views1 answer
Wordpress make wp user in db
SQL
0 vote343 views1 answer
One table with another
SQL
0 vote339 views1 answer
T-SQL Create Trigger
SQL
4 votes334 views3 answers
Is not null sql
SQL