single sql, multiple schemas, one result set - Mailing list pgsql-general

Suppose a DB with dozens of schemas with same structure.
DB
  Schema1
    Table1
    Table2
  Schema2
    Table1
    Table2
  Schema3
    Table1
    Table2
Then we want to execute a SQL on specific schemas and the result of it could
be a UNION ALL. So, how could be a function that runs that SQL on each
schema and results just on result set ?

Then I would use something like ...
select * from SQLFromMultipleShema(Array['Schema1,Schema3'],'select count(*)
from Table2');




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html