Обсуждение: [PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account

Поиск

Список

Период

Сортировка

[PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account

От

Dinesh Chandra 12108

Дата:

17 апреля 2017 г., 20:00:14

Hi Experts,

How can we create a materialized view in PostgreSQL which can be access by all the user account in all Database?

Regards,

Dinesh Chandra

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

От

"David G. Johnston"

Дата:

17 апреля 2017 г., 20:12:56

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.

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: [PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account

[PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account

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