mercredi 25 février 2015

selecting rows from table under public schema where each row acts as a schema


in My DB,I have customer table in public schema.And then I have 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. Now I want to select all the customers having particular 'portal name'.But portal table is inside customer schema.So How should I query to 'postgres' in this situation.


EDIT-I have found solution using php script but is there anything that we can do on DB level.





Aucun commentaire:

Enregistrer un commentaire