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.