pg_database_owner
pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema.
Reading PG 18·Select a recorded version
- Name
- pg_database_owner
- Manual terminology
- Predefined roles
Definition PG 18
pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75
Text language: en · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75