Sql find table by name

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;

Source: dataedo.com

Similar codes

0 vote248 views1 answer
Postgresql print variable
SQL
0 vote206 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote187 views2 answers
MySQL top percent
SQL
14 votes186 views2 answers
Oracle limit rows
SQL
0 vote171 views1 answer
How to change null display in psql
SQL
10 votes214 views6 answers
Sql between
SQL
0 vote211 views2 answers
SQL Server Standard
SQL
0 vote200 views1 answer
Oracle flush Shared Pool
SQL
3 votes186 views2 answers
Mysql HAVING
SQL
0 vote180 views1 answer
Date datatype in livesql
SQL