/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 vote332 views1 answer
Sqlite update only if greater
SQL
7 votes380 views2 answers
How to create index mysql
SQL
8 votes334 views1 answer
Declare table variable sql server
SQL
0 vote345 views1 answer
Select lowest values sql
SQL
0 vote329 views3 answers
Insert query in ci
SQL
1 vote317 views1 answer
Load sql into mamp
SQL
6 votes341 views2 answers
Mysql interval 1 day
SQL
0 vote326 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote313 views1 answer
Get time component of datetime sql
SQL
31 votes325 views1 answer
Postgresql add column with constraint
SQL