1select table_schema,
2 table_name
3from information_schema.tables
4where table_name like 'payment%'
5 and table_schema not in ('information_schema', 'pg_catalog')
6 and table_type = 'BASE TABLE'
7order by table_name,
8 table_schema;
9