On Tue, 2021-04-06 at 13:22 +0530, aditya desai wrote: > We have to access data from one schema to another. We have created > a view for this but performance is not good. The performance of a view that is just a simple SELECT to a table in a different schema will be just as good as using that table directly. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com