/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

16 votes218 views1 answer
Mysql reset auto increment value
SQL
0 vote210 views1 answer
Create user faunadb
SQL
31 votes211 views4 answers
Mysql grant execute
SQL
0 vote208 views1 answer
Sql server concat null
SQL
1 vote211 views3 answers
Connect to mysql c# connection string C#
SQL
8 votes202 views1 answer
How to remove tables from postgresql
SQL
0 vote191 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote207 views1 answer
Mysql terminal list table
SQL
3 votes202 views3 answers
Concatenation in sql
SQL
1 vote218 views1 answer
Mysql print variable
SQL