/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 vote391 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote377 views1 answer
Providername system.data. mysql
SQL
0 vote324 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote356 views1 answer
Python connect microsoft sql server
SQL
3 votes399 views1 answer
Mysql group_concat distinct
SQL
0 vote370 views1 answer
Command line mysql xampp
SQL
0 vote338 views1 answer
T sql return on letters only
SQL
0 vote369 views1 answer
Difference between min and max date sql
SQL
0 vote326 views1 answer
Generate sequence number in sql server
SQL
0 vote338 views1 answer
Mysql autoincrement valor inicial
SQL