Re: [PERFORM] Create a materialized view in PostgreSQL which can beaccess by all the user account

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [PERFORM] Create a materialized view in PostgreSQL which can beaccess by all the user account
Дата
Msg-id CAKFQuwYfkEMJLdECzBZC8=fqHDRM6o5JxU23FeENSJ-NHcmRzQ@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account  (Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>)
Список pgsql-performance
Дерево обсуждения
On Mon, Apr 17, 2017 at 10:00 AM, Dinesh Chandra 12108 <Dinesh.Chandra@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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dinesh Chandra 12108
Дата:
Сообщение: [PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account
Следующее
От: ROBERT PRICE
Дата:
Сообщение: [PERFORM] Insert Concurrency