/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

1 vote148 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote143 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote129 views1 answer
Change date format in oracle query
SQL
-2 votes138 views1 answer
Remove root password mysql
SQL
7 votes135 views1 answer
Buy forge mods server hosting
SQL
2 votes122 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
1 vote108 views1 answer
Sql convert month name to number
SQL
13 votes134 views1 answer
Select count of distinct values sql
SQL
0 vote146 views1 answer
Get enginge db mysql
SQL
0 vote139 views1 answer
Sql server isnull function nor working count
SQL