/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 vote315 views4 answers
Postgresql between month
SQL
0 vote350 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
1 vote323 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote380 views1 answer
Mysql get longest string in column
SQL
0 vote330 views1 answer
Postgresql stored procedure update table values
SQL
1 vote277 views1 answer
Stored procedure return value
SQL
0 vote310 views1 answer
Postgresql find missing id
SQL
0 vote366 views1 answer
Sql doesn't contain
SQL
2 votes308 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
2 votes325 views2 answers
Calculate percentage in sql
SQL