/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

4 votes196 views1 answer
Mysql insert from local csv
SQL
0 vote207 views1 answer
Dapper run sql script with parameters
SQL
1 vote209 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote199 views1 answer
Codeigniter dbforge add index
SQL
0 vote206 views1 answer
Declare or use variable in snowflake
SQL
0 vote210 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
2 votes208 views2 answers
Mamp connect mysql terminal
SQL
3 votes239 views3 answers
Create table in SQL Server
SQL
0 vote212 views1 answer
Window function to forward fill
SQL
0 vote216 views2 answers
How to login to mysql as normal user in ubuntu
SQL