CREATE FOREIGN TABLE ... LIKE
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.
Foreign Data Wrappers
Description
Specify a source table from which the new table automatically copies all column names, their data types, and their not-null constraints.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "create-foreign-table-like",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "CREATE FOREIGN TABLE ... LIKE",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "CREATE FOREIGN TABLE ... LIKE",
"NameLocale": "en",
"GroupKey": "foreign-data-wrappers",
"GroupName": "Foreign Data Wrappers",
"GroupLocale": "en",
"Ordinal": 1,
"GroupOrder": 17,
"Facts": {
"feature": {
"description": "Specify a source table from which the new table automatically copies all column names, their data types, and their not-null constraints.",
"name": "CREATE FOREIGN TABLE ... LIKE",
"versions": {
"18": "Yes"
}
},
"group": "Foreign Data Wrappers",
"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": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "18",
"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": "CREATE FOREIGN TABLE ... LIKE",
"BodyHTML": "\u003cp\u003eSpecify a source table from which the new table automatically copies all column names, their data types, and their not-null constraints.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "60cf24582830366bebb9efe491d890a0f210e6e8b565a6d8cdeb1604ff929e5c",
"Payload": {
"description": "Specify a source table from which the new table automatically copies all column names, their data types, and their not-null constraints.",
"name": "CREATE FOREIGN TABLE ... LIKE",
"versions": {
"18": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "CREATE FOREIGN TABLE ... LIKE",
"BodyHTML": "\u003cp\u003e可指定一个源表，使新建外部表自动复制其列名、数据类型以及 \u003ccode\u003eNOT NULL\u003c/code\u003e 约束。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "95cd212f7db8ba9ba8fd7896fcc933c5f24deedeb6303f81310fbbeaaa0dd13d",
"Payload": {
"description": "可指定一个源表，使新建外部表自动复制其列名、数据类型以及 `NOT NULL` 约束。",
"name": "CREATE FOREIGN TABLE ... LIKE"
}
}
],
"GroupTitles": {
"en": "Foreign Data Wrappers",
"zh-Hans": "外部数据包装器"
}
}