Search for column name in psql

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;

Similar codes

1 vote113 views1 answer
Avg mysql
SQL
8 votes123 views1 answer
Today minus 15 days postgresql
SQL
0 vote126 views1 answer
Big table in mysql
SQL
0 vote131 views1 answer
Compare subqueries oracle
SQL
0 vote151 views1 answer
Find wordpress version in database
SQL
49 votes203 views6 answers
Get duplicate records in sql
SQL
-1 vote85 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
1 vote126 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes146 views2 answers
Mysql select database
SQL
1 vote136 views3 answers
Remove unique key from a table
SQL