Thanks will check.
On Tue, Apr 6, 2021 at 4:11 PM hubert depesz lubaczewski <depesz(at)depesz(dot)com>
wrote:
> On Tue, Apr 06, 2021 at 01:22:31PM +0530, aditya desai wrote:
> > Hi,
> > We have to access data from one schema to another. We have created a
> view for this but performance is not good. We tried
> > materialized views as well but Refresh MV is creating problem as it puts
> and access exclusive locks.
> > Is there any other way to achieve this?
>
> Yes, just use the other table right in your query. There is no need to
> add wrappers.
>
> select * from schema1.table join schema2.table on ...
>
> depesz
>