View of Union Multiple Tables - Only If table EXISTS
От | Avi Weinberg |
---|---|
Тема | View of Union Multiple Tables - Only If table EXISTS |
Дата | |
Msg-id | DB9PR07MB718071BE91911B930C1DFC08CBE79@DB9PR07MB7180.eurprd07.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: View of Union Multiple Tables - Only If table EXISTS
|
Список | pgsql-general |
Hi,
I would like to create a view which is UNION of multiple tables with the same name from different schemas.
Select col1, col2 from schemaA.table
UNION
Select col1, col2 from schemaB.table
However, it is possible that in some of the schemas the table was not created yet.
I know I can check in which schemas the table exists and then create the view, but at any given time the table can be added to other schemas. In that case, I will always need to check if the view is up-to-date before accessing it and this makes the view useless.
Is it possible to write the view syntax once and it will do some type of SELECT IF EXISTS.
Thanks
Avi
В списке pgsql-general по дате отправления: