/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 vote200 views1 answer
Sql query to return field name of a table
SQL
0 vote218 views1 answer
T-SQL Create Trigger
SQL
32 votes187 views6 answers
Sql count where
SQL
0 vote201 views1 answer
How to remove quotes from a string in ssis load file
SQL
2 votes193 views1 answer
Power query concatenate
SQL
1 vote208 views1 answer
How do you use sql in you company
SQL
0 vote191 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote175 views3 answers
String to int mysql
SQL
0 vote188 views1 answer
Mysql workbench procedure
SQL
-2 votes186 views1 answer
Remove root password mysql
SQL