Re: Create a materialized view in PostgreSQL which can be access by all the user account

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Create a materialized view in PostgreSQL which can be access by all the user account
Date: 2017-04-17 17:12:56
Message-ID: CAKFQuwYfkEMJLdECzBZC8=fqHDRM6o5JxU23FeENSJ-NHcmRzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 17, 2017 at 10:00 AM, Dinesh Chandra 12108 <
Dinesh(dot)Chandra(at)cyient(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ROBERT PRICE 2017-04-18 02:55:41 Insert Concurrency
Previous Message Dinesh Chandra 12108 2017-04-17 17:00:14 Create a materialized view in PostgreSQL which can be access by all the user account