pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate a materialized view in PostgreSQL which can be access by all the user account
2+ messages / 2 participants
[nested] [flat]
* Create a materialized view in PostgreSQL which can be access by all the user account
@ 2017-04-17 17:00 Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
2017-04-17 17:12 ` Re: Create a materialized view in PostgreSQL which can be access by all the user account David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Dinesh Chandra 12108 @ 2017-04-17 17:00 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Create a materialized view in PostgreSQL which can be access by all the user account
2017-04-17 17:00 Create a materialized view in PostgreSQL which can be access by all the user account Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
@ 2017-04-17 17:12 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2017-04-17 17:12 UTC (permalink / raw)
To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-04-17 17:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-17 17:00 Create a materialized view in PostgreSQL which can be access by all the user account Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
2017-04-17 17:12 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox