COPY FROM ... WHERE
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.
数据导入和导出
Description
在使用 COPY FROM 时，通过 WHERE 子句指定从数据源加载哪些行
Selected version: PostgreSQL 18
No
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 · 3a44105f53bae5f90874ce45018859c9034d8f33dc61f544794749949222c11a
{
"Key": "330",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "330",
"SourceHash": "3a44105f53bae5f90874ce45018859c9034d8f33dc61f544794749949222c11a",
"Name": "COPY FROM ... WHERE",
"NameLocale": "en",
"GroupKey": "19",
"GroupName": "数据导入和导出",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 18,
"Facts": {
"featuredescription": "在使用 COPY FROM 时，通过 WHERE 子句指定从数据源加载哪些行",
"featurename": "COPY FROM ... WHERE",
"group_id": 19,
"id": 330,
"v10": 0,
"v11": 0,
"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": 0,
"v93": 0,
"v94": 0,
"v95": 0,
"v96": 0
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"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": "no",
"EvidenceKind": "legacy-database:v92",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": false,
"Original": 0
}
],
"Texts": [
{
"Locale": "en",
"Title": "COPY FROM ... WHERE",
"BodyHTML": "",
"SourceHash": "3a44105f53bae5f90874ce45018859c9034d8f33dc61f544794749949222c11a",
"ContentHash": "d38acdcc6e3e064ad98aa182c8c9e943e612d0948e629376dc84694314a5455f",
"Payload": {
"name": "COPY FROM ... WHERE"
}
},
{
"Locale": "zh-Hans",
"Title": "",
"BodyHTML": "\u003cp\u003e在使用 COPY FROM 时，通过 WHERE 子句指定从数据源加载哪些行\u003c/p\u003e\n",
"SourceHash": "3a44105f53bae5f90874ce45018859c9034d8f33dc61f544794749949222c11a",
"ContentHash": "257dabb0ad8dd9a0b89365890bfb8e056a70e3f6418f00fb339f1303ead77662",
"Payload": {
"description": "在使用 COPY FROM 时，通过 WHERE 子句指定从数据源加载哪些行"
}
}
],
"GroupTitles": {
"zh-Hans": "数据导入和导出"
},
"RelatedKey": "copy-from-where"
}