/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 vote383 views2 answers
Sql query inner join 3 tables
SQL
7 votes357 views6 answers
Nth highest salary in sql
SQL
2 votes346 views2 answers
Sqlite_busy: database is locked
SQL
1 vote365 views1 answer
Mysql view current queries
SQL
1 vote349 views1 answer
Loading local data is disabled mysql
SQL
0 vote400 views1 answer
T-sql delete view if exists
SQL
0 vote371 views1 answer
Android sqlite add column if not exists
SQL
8 votes405 views2 answers
How to fetch data from database without last column
SQL
25 votes448 views4 answers
Import mysql dump command line
SQL
3 votes365 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL