UNION ALL operator in postgresql #248
Replies: 1 comment 2 replies
-
|
Hello and sorry for the delay. I have only recently been looking at the discussion section. |
Beta Was this translation helpful? Give feedback.
-
|
@toluaina are there any future plans for generating the elastic search indexes from user-defined SQL queries in postgresql dialect instead of the schema files ? like AWS Glue Elastic Views for instance |
Beta Was this translation helpful? Give feedback.
-
|
Hmm. there are no plans for this but a POC might be a good place to start. Although I don't have the capacity to take this on at the moment |
Beta Was this translation helpful? Give feedback.
-
Right now I have a bunch of PostgreSQL Views that I need to re-write into elasticsearch indexes using pgsync , however I came across a particular problem, which is that I cannot find anything to emulate the "UNION ALL" query in postgresql , so for example if I have this view
Is there anyway for me to achieve a similar result when using pgsync ?
Beta Was this translation helpful? Give feedback.
All reactions