TABLE statement
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.
SQL
Description
SQL standard shorthand version for SELECT * FROM
For more information, please see the documentation on SELECT
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 146
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "table-statement",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "TABLE statement",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "TABLE statement",
"NameLocale": "en",
"GroupKey": "sql",
"GroupName": "SQL",
"GroupLocale": "en",
"Ordinal": 18,
"GroupOrder": 3,
"Facts": {
"feature": {
"description": "SQL standard shorthand version for `SELECT * FROM`\r\n\r\nFor more information, please see the documentation on [`SELECT`](https://www.postgresql.org/docs/current/sql-select.html)",
"name": "TABLE statement",
"versions": {
"8.4": "Yes"
}
},
"group": "SQL",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.0",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.1",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.2",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "TABLE statement",
"BodyHTML": "\u003cp\u003eSQL standard shorthand version for \u003ccode\u003eSELECT * FROM\u003c/code\u003e\u003c/p\u003e\n\u003cp\u003eFor more information, please see the documentation on \u003ca href=\"https://www.postgresql.org/docs/current/sql-select.html\" rel=\"nofollow\"\u003e\u003ccode\u003eSELECT\u003c/code\u003e\u003c/a\u003e\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "b301e40a81cdd418d8fb9d4a4ad648daeacd9de17d908945f7e529c4a3cdf6d8",
"Payload": {
"description": "SQL standard shorthand version for `SELECT * FROM`\r\n\r\nFor more information, please see the documentation on [`SELECT`](https://www.postgresql.org/docs/current/sql-select.html)",
"name": "TABLE statement",
"versions": {
"8.4": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "TABLE 语句",
"BodyHTML": "\u003cp\u003eSQL 标准的 \u003ccode\u003eSELECT * FROM\u003c/code\u003e 简写形式\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/current/sql-select.html\" rel=\"nofollow\"\u003e\u003ccode\u003eSELECT\u003c/code\u003e\u003c/a\u003e 文档\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "af8da96c4518911618a35d4a20acff79f8d7c38d0a68476751fd42993f48c061",
"Payload": {
"description": "SQL 标准的 `SELECT * FROM` 简写形式\n\n更多信息请参阅 [`SELECT`](https://www.postgresql.org/docs/current/sql-select.html) 文档",
"name": "TABLE 语句"
}
}
],
"GroupTitles": {
"en": "SQL",
"zh-Hans": "SQL"
},
"LegacyIDs": [
"146"
]
}