/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

5 votes115 views1 answer
How to use rank function in sql
SQL
0 vote140 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
4 votes102 views2 answers
Tsql utf to local time
SQL
2 votes138 views2 answers
Mysql date range
SQL
0 vote91 views1 answer
Count the table indatabase
SQL
1 vote99 views1 answer
T-SQL Alter the column data type
SQL
7 votes103 views1 answer
Sql disable safe mode
SQL
0 vote161 views1 answer
Postgresql powershell query
SQL
5 votes94 views1 answer
Sql first day of current year
SQL
-1 vote102 views2 answers
Postgres autoincrement primary key
SQL