Postgres Pro
Downloads
Home   >   mailing lists

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

From Guyren Howe
Subject Re: single sql, multiple schemas, one result set
Date
Msg-id D01ABCC8-4DD4-401F-9D38-5B9ECE2AC1AD@gmail.com
Whole thread Raw
In response to single sql, multiple schemas, one result set  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Tree view
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@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


pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: single sql, multiple schemas, one result set
Next
From: Rob Sargent
Date:
Subject: Re: single sql, multiple schemas, one result set