sql find table by name

Solutions on MaxInterview for sql find table by name by the best coders in the world

showing results for - "sql find table by name"
Leonie
05 Oct 2019
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