{"kind": "role", "major": "18", "item": {"slug": "pg_database_owner", "name": "pg_database_owner", "name_zh": "pg_database_owner", "category": "Administration", "summary": "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.", "aliases": [], "versions": {"14": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 14.24 Documentation", "label": "14.24", "major": "14", "channel": "stable", "revision": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, "sources": [{"url": "/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14.24 Documentation", "sha256": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, {"url": "https://www.postgresql.org/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. The role conveys no rights at first. Like any role, it can own objects or 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 exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "15": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 15.19 Documentation", "label": "15.19", "major": "15", "channel": "stable", "revision": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, "sources": [{"url": "/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15.19 Documentation", "sha256": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, {"url": "https://www.postgresql.org/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or 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 exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "16": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 16.15 Documentation", "label": "16.15", "major": "16", "channel": "stable", "revision": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, "sources": [{"url": "/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16.15 Documentation", "sha256": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, {"url": "https://www.postgresql.org/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or 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 exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "17": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 17.11 Documentation", "label": "17.11", "major": "17", "channel": "stable", "revision": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, "sources": [{"url": "/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17.11 Documentation", "sha256": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, {"url": "https://www.postgresql.org/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or 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 exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "18": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["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."]}, "19": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["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."]}, "20": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["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."]}}, "content_hash": "8ff3eb66690f329a62d6ab42bf0721b4144b8bedf0bd6803214e9ca07a3df2b1", "imported_at": "2026-09-27T09:57:59.044"}, "snapshot": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["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."]}, "comparison": {"left": "13", "right": "14", "status": "added", "diff": "--- PostgreSQL 13\n+++ PostgreSQL 14\n@@ -1 +1,14 @@\n-Not recorded in this version\n+{\n+  \"facts\": [\n+    {\n+      \"label\": \"Name\",\n+      \"value\": \"pg_database_owner\"\n+    },\n+    {\n+      \"label\": \"Manual terminology\",\n+      \"value\": \"Predefined roles\"\n+    }\n+  ],\n+  \"signature\": null,\n+  \"tables\": null\n+}"}}