/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 vote116 views4 answers
Mysql on kubernetes
SQL
0 vote135 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote112 views1 answer
Sql select lowest value row
SQL
1 vote135 views1 answer
Create new index takes long time postgresql
SQL
1 vote131 views1 answer
Set id count mysql
SQL
0 vote113 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote112 views1 answer
Order by with where clause in mysql
SQL
0 vote112 views1 answer
Delete insert record in sql server
SQL
2 votes120 views1 answer
Oracle run_duration average
SQL
2 votes123 views2 answers
Sql query to list all tables in a database sql server
SQL