COPY ... ON_ERROR
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 Import & Export
Description
The new ON_ERROR option for COPY provides the option to ignore and discard error rows. The default behavior is ON_ERROR stop the import.
See COPY.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 433
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "copy-on_error",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "COPY ... ON_ERROR",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "COPY ... ON_ERROR",
"NameLocale": "en",
"GroupKey": "data-import-export",
"GroupName": "Data Import \u0026 Export",
"GroupLocale": "en",
"Ordinal": 2,
"GroupOrder": 12,
"Facts": {
"feature": {
"description": "The new `ON_ERROR` option for COPY provides the option to ignore and discard error rows. The default behavior is ON_ERROR stop the import.\r\n\r\nSee [`COPY`](https://www.postgresql.org/docs/current/sql-copy.html).",
"name": "COPY ... ON_ERROR",
"versions": {
"17": "Yes"
}
},
"group": "Data Import \u0026 Export",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "17",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "17",
"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": "COPY ... ON_ERROR",
"BodyHTML": "\u003cp\u003eThe new \u003ccode\u003eON_ERROR\u003c/code\u003e option for COPY provides the option to ignore and discard error rows. The default behavior is ON_ERROR stop the import.\u003c/p\u003e\n\u003cp\u003eSee \u003ca href=\"https://www.postgresql.org/docs/current/sql-copy.html\" rel=\"nofollow\"\u003e\u003ccode\u003eCOPY\u003c/code\u003e\u003c/a\u003e.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "803c3eb8c31ec4ac4b331df06c426d970ed916a9b07700bb82d60c5316a10a17",
"Payload": {
"description": "The new `ON_ERROR` option for COPY provides the option to ignore and discard error rows. The default behavior is ON_ERROR stop the import.\r\n\r\nSee [`COPY`](https://www.postgresql.org/docs/current/sql-copy.html).",
"name": "COPY ... ON_ERROR",
"versions": {
"17": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "COPY ... ON_ERROR",
"BodyHTML": "\u003cp\u003e\u003ccode\u003eCOPY\u003c/code\u003e 新增 \u003ccode\u003eON_ERROR\u003c/code\u003e 选项，可在导入时忽略并丢弃出错的行；默认行为仍为遇错停止。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "28f117a037528da87b8196ea62fc2e472701d69e04446c9ae006367111c53eb1",
"Payload": {
"description": "`COPY` 新增 `ON_ERROR` 选项，可在导入时忽略并丢弃出错的行；默认行为仍为遇错停止。",
"name": "COPY ... ON_ERROR"
}
}
],
"GroupTitles": {
"en": "Data Import \u0026 Export",
"zh-Hans": "数据导入和导出"
},
"LegacyIDs": [
"433"
]
}