/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 vote214 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote247 views1 answer
Mysql get first 2 characters of string
SQL
5 votes220 views1 answer
Ora-00054 find lock
SQL
0 vote218 views1 answer
Sql add calculated column
SQL
2 votes172 views1 answer
Sql view column data type
SQL
0 vote239 views1 answer
Oracle current date minus 1 day
SQL
-1 vote220 views1 answer
Capitole toulouse
SQL
0 vote240 views1 answer
Add two days to current date in sql when creating tables
SQL
2 votes231 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote226 views2 answers
Grab part of a string sql
SQL