/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 vote341 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
8 votes327 views1 answer
Sql remove characters from string right
SQL
0 vote361 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote407 views1 answer
Pl sql join 3 tables
SQL
3 votes358 views2 answers
Sqlite print all column names
SQL
0 vote353 views1 answer
C# add a textbox in mysql select
SQL
0 vote354 views1 answer
Suse status MySQL
SQL
0 vote322 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
2 votes363 views1 answer
Ifnull postgres
SQL
13 votes333 views4 answers
Mysql select last 10 rows
SQL