Thanks will check. On Tue, Apr 6, 2021 at 4:11 PM hubert depesz lubaczewski <dep...@depesz.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 >
