/SQL/Postgresql search all tables for column name

Postgresql search all tables for column name

Search for tables with name postgresql

select table_schema,
       table_name
from information_schema.tables
where table_name like 'payment%'
      and table_schema not in ('information_schema', 'pg_catalog')
      and table_type = 'BASE TABLE'
order by table_name,
         table_schema;
Code has been copied

Source: dataedo.com

Postgresql search all tables for column name

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

16 votes207 views1 answer
Sqlserver add column to table
SQL
0 vote206 views1 answer
Drop CHECK constraint sql
SQL
0 vote209 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote225 views1 answer
Postgresql custom order by
SQL
0 vote197 views1 answer
Mysql start of today
SQL
0 vote214 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
37 votes207 views3 answers
Postgresql insert column
SQL
19 votes217 views5 answers
Date between in mysql
SQL
0 vote231 views1 answer
Mysql changer nom table
SQL
0 vote194 views1 answer
Call function sql oracle
SQL