Trusted Extensions
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Extensions
Description
Extensions that are marked as "trusted" by a superuser can subsequently be installed via CREATE EXTENSION by unprivileged users. Some functions are marked as "trusted" by default.
For more information, please see the CREATE EXTENSION documentation.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 347
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "trusted-extensions",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Trusted Extensions",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Trusted Extensions",
"NameLocale": "en",
"GroupKey": "extensions",
"GroupName": "Extensions",
"GroupLocale": "en",
"Ordinal": 2,
"GroupOrder": 20,
"Facts": {
"feature": {
"description": "Extensions that are marked as \"trusted\" by a superuser can subsequently be installed via `CREATE EXTENSION` by unprivileged users. Some functions are marked as \"trusted\" by default.\r\n\r\nFor more information, please see the [`CREATE EXTENSION`](https://www.postgresql.org/docs/current/sql-createextension.html) documentation.",
"name": "Trusted Extensions",
"versions": {
"13": "Yes"
}
},
"group": "Extensions",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Trusted Extensions",
"BodyHTML": "\u003cp\u003eExtensions that are marked as \u0026#34;trusted\u0026#34; by a superuser can subsequently be installed via \u003ccode\u003eCREATE EXTENSION\u003c/code\u003e by unprivileged users. Some functions are marked as \u0026#34;trusted\u0026#34; by default.\u003c/p\u003e\n\u003cp\u003eFor more information, please see the \u003ca href=\"https://www.postgresql.org/docs/current/sql-createextension.html\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE EXTENSION\u003c/code\u003e\u003c/a\u003e documentation.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "2d424dd0a390b4d8913ed57b3e800864b2ad2f46ef0c6f3e0dd48b757fc51f78",
"Payload": {
"description": "Extensions that are marked as \"trusted\" by a superuser can subsequently be installed via `CREATE EXTENSION` by unprivileged users. Some functions are marked as \"trusted\" by default.\r\n\r\nFor more information, please see the [`CREATE EXTENSION`](https://www.postgresql.org/docs/current/sql-createextension.html) documentation.",
"name": "Trusted Extensions",
"versions": {
"13": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "受信任的扩展",
"BodyHTML": "\u003cp\u003e标记为“受信任”的扩展可由对当前数据库具有 CREATE 权限的非超级用户通过 \u003ccode\u003eCREATE EXTENSION\u003c/code\u003e 安装。某些内置扩展默认标记为“受信任”。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/current/sql-createextension.html\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE EXTENSION\u003c/code\u003e\u003c/a\u003e 文档。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "29a72b68039c451bba4454c1b35ab26b15b198dad25961fa6d4d1875c1bff18d",
"Payload": {
"description": "标记为“受信任”的扩展可由对当前数据库具有 CREATE 权限的非超级用户通过 `CREATE EXTENSION` 安装。某些内置扩展默认标记为“受信任”。\r\n\r\n更多信息请参阅 [`CREATE EXTENSION`](https://www.postgresql.org/docs/current/sql-createextension.html) 文档。",
"name": "受信任的扩展"
}
}
],
"GroupTitles": {
"en": "Extensions",
"zh-Hans": "扩展"
},
"LegacyIDs": [
"347"
]
}