/SQL/Search for tables with name postgresql

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

Similar codes

0 vote220 views3 answers
Magento 2 order delete from db
SQL
2 votes215 views1 answer
How to add where command in update comand with joins
SQL
3 votes204 views1 answer
How to remove characters from string in mysql
SQL
11 votes228 views3 answers
Pl sql example
SQL
0 vote209 views1 answer
Sql get guid
SQL
0 vote277 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote216 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote209 views1 answer
In mysql workbench contnent not feching
SQL
0 vote236 views1 answer
T-sql email validation
SQL
9 votes239 views6 answers
Check constraint in sql
SQL