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

2 votes317 views1 answer
How to delete view in sql
SQL
0 vote341 views1 answer
SQL-Arten
SQL
0 vote520 views1 answer
The differnece between to values in sql
SQL
6 votes343 views2 answers
Sql sequence
SQL
0 vote301 views2 answers
Sqlite
SQL
0 vote305 views1 answer
Add column not null with default value postgres
SQL
0 vote349 views1 answer
Create user faunadb
SQL
1 vote325 views1 answer
Oracle apex version view
SQL
1 vote318 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote355 views1 answer
Mariadb cast to int
SQL