/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

3 votes205 views3 answers
Order by postgres
SQL
8 votes190 views1 answer
How to remove tables from postgresql
SQL
20 votes208 views3 answers
Update values in select statement sql
SQL
0 vote199 views1 answer
Create a plsql object
SQL
10 votes209 views2 answers
Mysql drop database if exists
SQL
0 vote201 views1 answer
Create table split string function in sql server
SQL
6 votes214 views6 answers
Rename column postgres
SQL
7 votes193 views1 answer
Mysql iif
SQL
11 votes210 views5 answers
Sql server reset identity
SQL
5 votes189 views1 answer
Oracle columns in all_tables
SQL