/SQL/Find a column in all tables postgres

Find a column in all tables postgres

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;
Code has been copied

Source: dataedo.com

Similar codes

0 vote308 views1 answer
Oracle concat datetime
SQL
0 vote280 views1 answer
Sqlite select split string
SQL
-1 vote277 views3 answers
Check table exist postgresql
SQL
1 vote224 views1 answer
How to run sql script
SQL
0 vote297 views1 answer
Oracle for loop on list
SQL
0 vote286 views1 answer
Hex string sql becomes int64
SQL
0 vote336 views1 answer
Finding leap year in sql
SQL
0 vote286 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote283 views1 answer
Mysql pad zeros
SQL
0 vote245 views1 answer
Bigquery information_schema schema all columns
SQL