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 vote253 views1 answer
Sql order by except one row
SQL
0 vote254 views1 answer
Add mysql database to power bi web
SQL
0 vote232 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote230 views1 answer
How to find unique key in sql
SQL
1 vote181 views1 answer
File /etc/init.d/mysql not exists
SQL
10 votes236 views3 answers
Sql check double value
SQL
0 vote193 views0 answer
How to connect to datbase in springboot
SQL
13 votes234 views2 answers
Oracle inner join
SQL
0 vote257 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote232 views1 answer
Not between mysql
SQL