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 vote134 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote127 views1 answer
What does leave do in mysql
SQL
11 votes120 views3 answers
Sql_mode=only_full_group_by
SQL
1 vote131 views1 answer
Select users with same username
SQL
0 vote128 views1 answer
How to add boolean column in postgresql
SQL
0 vote141 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote165 views1 answer
Grouping by email domain mysql
SQL
0 vote117 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
14 votes141 views4 answers
Online sql compiler
SQL
0 vote87 views3 answers
Mysql calculate age from date of birth
SQL