SELECT DISTINCT tablename, schemaname FROM pg_table_def where tablename like '%<part_of_table_name>%'
<part_of_table_name> with table name you are looking for. Since query uses
like you can just pass partial of table name.
pg_table_def only returns information about tables that are visible to the user, so if you haven’t found what you are looking for, it does not mean that table does not exist.