/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

3 votes281 views4 answers
Stop MySQL
SQL
0 vote270 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote324 views1 answer
Opensuse restart MySQL
SQL
0 vote260 views1 answer
Sum sqlserver
SQL
0 vote279 views1 answer
Oracle sql drop table
SQL
0 vote295 views1 answer
Mysql cli output to a file
SQL
0 vote301 views1 answer
Postgres list users and roles
SQL
0 vote279 views1 answer
Php get closest location by latitude longitude
SQL
5 votes270 views1 answer
Oracle scan source ddl
SQL
0 vote270 views1 answer
Mysql table variables
SQL