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 vote296 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
2 votes265 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote272 views1 answer
Select insert new table sql server
SQL
10 votes266 views3 answers
Sql check double value
SQL
18 votes263 views3 answers
Mysql number format
SQL
-1 vote309 views1 answer
Difference berween database and data base management system
SQL
11 votes260 views2 answers
Mysql disable safe mode
SQL
7 votes293 views1 answer
Buy forge mods server hosting
SQL
1 vote288 views3 answers
Reseed sql table primary key
SQL
0 vote270 views1 answer
Can you write relational algebra into sql queries
SQL