I have customer table in public schema. And I have a schema named after each customer. Each customer schema contains different tables like portals
, plugin
, ... When I want to select portals used by customer 'a', I can do select * from a.portal
.
I want to select all the customers having a particular 'portal name'. But portal table is inside customer schema. So how should I query in this situation?
I have found solution using a PHP script but is there anything that we can do on the DB level?
portal
tables differ among customers.