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 <mar...@f10.com.br> 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 >
