Re: single sql, multiple schemas, one result set

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Re: single sql, multiple schemas, one result set
Дата
Msg-id D01ABCC8-4DD4-401F-9D38-5B9ECE2AC1AD@gmail.com
обсуждение исходный текст
Ответ на single sql, multiple schemas, one result set  (PegoraroF10 <marcos@f10.com.br>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: PegoraroF10
Дата:
Сообщение: single sql, multiple schemas, one result set
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: single sql, multiple schemas, one result set