search for tables with name postgresql

Solutions on MaxInterview for search for tables with name postgresql by the best coders in the world

showing results for - "search for tables with name postgresql"
Sophia
15 Jan 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;
9Code has been copied