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

6 votes284 views5 answers
Get current date sql
SQL
0 vote294 views1 answer
Sql count more than 1
SQL
0 vote285 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
1 vote302 views1 answer
Postgresql pass array in function
SQL
0 vote290 views1 answer
Pl sql constraint user function
SQL
0 vote300 views1 answer
Sql server query database space available
SQL
2 votes280 views5 answers
Alter table primary key postgresql
SQL
1 vote337 views2 answers
Install sql server management studio ubuntu
SQL
2 votes312 views1 answer
Oracle trace file
SQL
0 vote269 views1 answer
Sql random decimal
SQL