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

45 votes342 views5 answers
Grant all privileges mysql
SQL
1 vote282 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote289 views1 answer
In query in sql
SQL
0 vote273 views1 answer
Convert .mdf to .bak
SQL
0 vote263 views1 answer
Flask sqlalchemy decimal
SQL
0 vote248 views1 answer
Sql random decimal
SQL
0 vote267 views2 answers
Sql 2 way of select unique
SQL
0 vote289 views1 answer
Mysql Install Ubuntu with native password
SQL
3 votes284 views2 answers
How to delete git repo locally
SQL
0 vote309 views3 answers
Select top 10 rows in sql
SQL