/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

2 votes343 views1 answer
Use cases condition in sql query laravel
SQL
0 vote301 views1 answer
Full syntax inner join
SQL
1 vote349 views1 answer
Sqlite update from another table
SQL
0 vote332 views1 answer
Stored function in sql
SQL
0 vote365 views2 answers
Mysql insert into multiple tables
SQL
0 vote326 views1 answer
Sql list dates between two dates
SQL
0 vote349 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
24 votes274 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote327 views1 answer
Jenkins SQLCMD run
SQL
0 vote324 views1 answer
Do postgresql
SQL