SELECT * FROM pg_catalog.pg_tables WHERE tablename LIKE '%soomething%';? Is it what you're looking for?