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

11 votes189 views4 answers
Update row in mysql
SQL
5 votes203 views1 answer
Oracle nls instance
SQL
1 vote164 views4 answers
Sql now
SQL
0 vote137 views1 answer
Plsql trigger insert update
SQL
0 vote189 views1 answer
Sql file in postgres with pgadmin
SQL
11 votes166 views2 answers
Having clause
SQL
0 vote212 views3 answers
Mysql CAST(amount as float)
SQL
0 vote270 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote185 views1 answer
Drop CHECK constraint sql
SQL
8 votes192 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL