Re: single sql, multiple schemas, one result set

[Guyren Howe <guyren@xxxxxxxxx>]

Make a view that joins all the things, with a column providing the name of the schema that they came from.

On Apr 3, 2018, at 10:47 , PegoraroF10 <marcos@xxxxxxxxxx> wrote:

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