{"Entry":{"collection":"func","key":"parse-ident","name":"parse_ident","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"7ee2c4b95e12a9cea69bd8089c6f2e4884d92404199088b7202d31b0c7ec56ce","derived_content_hash":"4c706062f598b5713c935e23a7bab88b2871aad34cf471b2d2dc951e679f9d31","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:5f6b22c945c87209d22936938a2f600b1cffe1b1d0d9cc238ec490b988b1c8b1","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.6","group":"string","group_label":"String Functions And Operators","groups":["string"],"imported_at":"2026-09-14T21:49:48.656429+08:00","last_version":"20","name":"parse_ident","name_key":"parse_ident","position":3021,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"ed4005b9ec7b352ec9de457169bf98dab846dedfe258345080134b2c2013aaba","repair":"wiki-repair-20261023"},"signature":"parse_ident ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","signature_count":1,"slug":"parse-ident","source_rev":"wiki-repair-20261023:5f6b22c945c87209d22936938a2f600b1cffe1b1d0d9cc238ec490b988b1c8b1","summary":"Splits qualified_identifier into an array of identifiers, removing any quoting of individual identifiers.","summary_zh":""}},"Definition":{"Collection":"func","Key":"parse-ident","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"parse-ident","SourceRevision":"wiki-repair-20261023:5f6b22c945c87209d22936938a2f600b1cffe1b1d0d9cc238ec490b988b1c8b1","Facts":{"description":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","description_html":"Splits the qualified identifier \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e.","description_zh":"将限定标识符 str 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 name[]。","description_zh_html":"将限定标识符 \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","doc":{"anchor":"FUNCTIONS-STRING-OTHER","file":"functions-string.html","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7eecd3bb343149124be0476a539f3c682476eab2a15489a0e0ad06fbb769ea9e","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"string","group_label":"字符串函数和操作符","lang":"en","layout":"table-new","pages":["functions-string.html"],"prose_only":false,"signatures":[{"description":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","description_html":"Splits the qualified identifier \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e.","description_zh":"将限定标识符 str 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 name[]。","description_zh_html":"将限定标识符 \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","examples":[{"expr":"parse_ident('\"SomeSchema\".someTable')","result":"{SomeSchema,sometable}"}],"html":"\u003ccode class=\"function\"\u003eparse_ident\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estrict\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003etext[]\u003c/code\u003e","returns":"text[]","text":"parse_ident ( str text [, strict boolean DEFAULT true] ) → text[]","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-string.html","sha256":"0446377e0eccc9299099dc4b4b293204c337e3abefcdc396e9698bc54dd1080b"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-STRING-OTHER","file":"functions-string.html","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"parse-ident","SourceDatabase":"center","Version":"18","Locale":"en","Title":"parse_ident","Summary":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","BodyHTML":"Splits the qualified identifier \u003cem\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode\u003ename[]\u003c/code\u003e.","SourceRevision":"wiki-repair-20261023:5f6b22c945c87209d22936938a2f600b1cffe1b1d0d9cc238ec490b988b1c8b1","ContentHash":"2c3c1f27bee536f6fe9c2ac5486c4ddc023d7bacb7c99c31c11dadb5bdd3b678","Payload":{"description":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","description_html":"Splits the qualified identifier \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e.","signatures":[{"description":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","description_html":"Splits the qualified identifier \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e.","description_zh":"将限定标识符 str 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 name[]。","description_zh_html":"将限定标识符 \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","examples":[{"expr":"parse_ident('\"SomeSchema\".someTable')","result":"{SomeSchema,sometable}"}],"html":"\u003ccode class=\"function\"\u003eparse_ident\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estrict\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003etext[]\u003c/code\u003e","returns":"text[]","text":"parse_ident ( str text [, strict boolean DEFAULT true] ) → text[]","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"c7ba09116e85444e2c5ac46993bed1d98924bab6597bec6bf5178ccab542479e","Text":"parse_ident ( str text [, strict boolean DEFAULT true] ) → text[]","Returns":"text[]","Payload":{"description":"Splits the qualified identifier str into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[].","description_html":"Splits the qualified identifier \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e, then such extra characters are ignored. (This behavior is useful for parsing names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e.","description_zh":"将限定标识符 str 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 name[]。","description_zh_html":"将限定标识符 \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e 拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为 \u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","examples":[{"expr":"parse_ident('\"SomeSchema\".someTable')","result":"{SomeSchema,sometable}"}],"html":"\u003ccode class=\"function\"\u003eparse_ident\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estr\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estrict\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003etext[]\u003c/code\u003e","returns":"text[]","text":"parse_ident ( str text [, strict boolean DEFAULT true] ) → text[]","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}