Re: Substitute for synonym in Oracle after migration to postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks will check.

On Tue, Apr 6, 2021 at 4:11 PM hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux