Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)
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.
Data Definition Language (DDL)
Description
allows online changes of a column datatype to a different one
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 63
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "changing-column-types-alter-table-alter-column-type",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)",
"NameLocale": "en",
"GroupKey": "data-definition-language-ddl",
"GroupName": "Data Definition Language (DDL)",
"GroupLocale": "en",
"Ordinal": 4,
"GroupOrder": 4,
"Facts": {
"feature": {
"description": "allows online changes of a column datatype to a different one",
"name": "Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)",
"versions": {
"8.1": "Yes"
}
},
"group": "Data Definition Language (DDL)",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.2",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.3",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.0",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.1",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.2",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.1",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)",
"BodyHTML": "\u003cp\u003eallows online changes of a column datatype to a different one\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "ba39b42f54f0d410bc59d7af4df5bd93f0b30f6920823fd9dcb1aa8beab59601",
"Payload": {
"description": "allows online changes of a column datatype to a different one",
"name": "Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)",
"versions": {
"8.1": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "更改列类型 (ALTER TABLE .. ALTER COLUMN TYPE)",
"BodyHTML": "\u003cp\u003e允许在线将列的数据类型更改为另一种类型\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "aa01d701fe4e59ba89855888af1fd114c044971c6eb0cd9a87b5773f359c8517",
"Payload": {
"description": "允许在线将列的数据类型更改为另一种类型",
"name": "更改列类型 (ALTER TABLE .. ALTER COLUMN TYPE)"
}
}
],
"GroupTitles": {
"en": "Data Definition Language (DDL)",
"zh-Hans": "数据定义语言 (DDL)"
},
"LegacyIDs": [
"63"
]
}