↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

ALTER object IF EXISTS

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.

No translation of this description is recorded. The original Chinese description is shown.

数据定义语言 (DDL)

Description

许多对象现在支持 ALTER 语句中的 IF EXISTS 子句,例如表、外部表、索引、序列等。

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesYesYesNoNoNoNoNoNoNoNo

Compare versions

Original documentation links

Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.

Complete source facts and provenance

legacy · center · 6fada67390c2652cfadfaed5774df04335105ed095c3d372faa5367d237a887c

{
  "Key": "228",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "228",
  "SourceHash": "6fada67390c2652cfadfaed5774df04335105ed095c3d372faa5367d237a887c",
  "Name": "ALTER object IF EXISTS",
  "NameLocale": "en",
  "GroupKey": "14",
  "GroupName": "数据定义语言 (DDL)",
  "GroupLocale": "zh-Hans",
  "Ordinal": 0,
  "GroupOrder": 7,
  "Facts": {
    "featuredescription": "许多对象现在支持 ALTER 语句中的 IF EXISTS 子句,例如表、外部表、索引、序列等。",
    "featurename": "ALTER object IF EXISTS",
    "group_id": 14,
    "id": 228,
    "v10": 1,
    "v11": 1,
    "v12": 1,
    "v13": 1,
    "v14": 0,
    "v15": 0,
    "v16": 0,
    "v17": 0,
    "v18": 0,
    "v74": 0,
    "v80": 0,
    "v81": 0,
    "v82": 0,
    "v83": 0,
    "v84": 0,
    "v90": 0,
    "v91": 0,
    "v92": 1,
    "v93": 1,
    "v94": 1,
    "v95": 1,
    "v96": 1
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "legacy-database:v10",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "legacy-database:v11",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "legacy-database:v12",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "legacy-database:v13",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "legacy-database:v14",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "legacy-database:v15",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "legacy-database:v16",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "17",
      "State": "no",
      "EvidenceKind": "legacy-database:v17",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "18",
      "State": "no",
      "EvidenceKind": "legacy-database:v18",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "7.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v74",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v80",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v81",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "legacy-database:v82",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "legacy-database:v83",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v84",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v90",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v91",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "legacy-database:v92",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "legacy-database:v93",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v94",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "legacy-database:v95",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "legacy-database:v96",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "ALTER object IF EXISTS",
      "BodyHTML": "",
      "SourceHash": "6fada67390c2652cfadfaed5774df04335105ed095c3d372faa5367d237a887c",
      "ContentHash": "0f4301b749e913ee82d13772ee6083812c137816b3890d48ff6a5b89492235cb",
      "Payload": {
        "name": "ALTER object IF EXISTS"
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "",
      "BodyHTML": "\u003cp\u003e许多对象现在支持 ALTER 语句中的 IF EXISTS 子句,例如表、外部表、索引、序列等。\u003c/p\u003e\n",
      "SourceHash": "6fada67390c2652cfadfaed5774df04335105ed095c3d372faa5367d237a887c",
      "ContentHash": "89cc00d481a8599f9877330334689977d29344b1d95a94b5d2e12940dd61b305",
      "Payload": {
        "description": "许多对象现在支持 ALTER 语句中的 IF EXISTS 子句,例如表、外部表、索引、序列等。"
      }
    }
  ],
  "GroupTitles": {
    "zh-Hans": "数据定义语言 (DDL)"
  },
  "RelatedKey": "alter-object-if-exists"
}

Complete source data JSON