UNION ALL operator in postgresql

[sherif-927]

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 ?

[toluaina]

Hello and sorry for the delay. I have only recently been looking at the discussion section.
There is no way to achieve this using pgsync as its a very specific case.
I'm planning to take a look at view soon so this might help

[sherif-927]

@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

[toluaina]

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