Gnanavel S <s(dot)gnanavel(at)gmail(dot)com> writes:
> try this,
> CREATE VIEW allops AS
> select operatorid,operatorname from acc1.operator where active=3Dtrue
> union
> select operatorid,operatorname from acc2.operator where active=3Dtrue
> ;
Most likely you want UNION ALL not just UNION.
regards, tom lane