/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 vote149 views1 answer
SAP Return
SQL
0 vote156 views1 answer
How to add more columns to a table in mysql
SQL
1 vote157 views1 answer
Oracle nvl2
SQL
0 vote165 views1 answer
How to create notes in mysql
SQL
0 vote246 views1 answer
Run mysql xampp shell
SQL
3 votes197 views2 answers
How to View column names of a table in SQL
SQL
0 vote153 views1 answer
Sql query contains multiple ids
SQL
1 vote183 views1 answer
Sql to mongodb query converter
SQL
1 vote172 views1 answer
Get current date in pyspark sql
SQL
27 votes170 views6 answers
Set password mysql
SQL