/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 vote117 views1 answer
Mysql multiple count
SQL
0 vote128 views1 answer
Sql sort ages
SQL
1 vote137 views1 answer
Postgres start database on linux
SQL
11 votes130 views3 answers
Change column name sql server management studio
SQL
4 votes135 views1 answer
Wilayah indonesia database
SQL
1 vote130 views1 answer
How to remove identity from a column in sql server
SQL
0 vote136 views1 answer
Sql column contains special character
SQL
0 vote137 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote154 views1 answer
Hour differeence in mysql
SQL
0 vote139 views1 answer
Sql server list table sizes
SQL