search for tables with name postgresql

select table_schema,<br /> table_name<br /> from information_schema.tables<br /> where table_name like ‘payment%’<br /> and table_schema not in (‘information_schema’, ‘pg_catalog’)<br /> and table_type=”BASE TABLE”<br /> order by table_name,<br /> table_schema;<br /> Code has been copied