On Mon, Apr 17, 2017 at 10:00 AM, Dinesh Chandra 12108 < dinesh.chan...@cyient.com> wrote:
> Hi Experts, > > > > How can we create a materialized view in PostgreSQL which can be access by > all the user account in all Database? > Databases are isolated - while connected to one you cannot directly see objects in another. You need to use something like postgres_fdw to link current database and the one containing the materialized view together. https://www.postgresql.org/docs/9.6/static/postgres-fdw.html And ensure the proper permissions are setup. https://www.postgresql.org/docs/9.6/static/sql-grant.html David J.
