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 vote350 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
4 votes290 views1 answer
Search column by name mysql
SQL
0 vote269 views1 answer
Mysql money value
SQL
1 vote322 views1 answer
Sql select row with max date
SQL
15 votes293 views5 answers
Show tables in oracle
SQL
0 vote297 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
1 vote296 views3 answers
Rows, INSERT INTO
SQL
1 vote232 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote271 views1 answer
T-SQL Retry (deadlock)
SQL
3 votes277 views1 answer
Sql replace character in string in all records
SQL