{"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","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"],"signature":"parse_ident ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","signature_count":1,"slug":"parse-ident","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Splits qualified_identifier 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 \u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-STRING-OTHER","file":"functions-string.html","slug":"18"},"group":"string","group_label":"String Functions And Operators","lang":"en","layout":"table-new","pages":["functions-string.html"],"prose_only":false,"signatures":[{"description":"Splits qualified_identifier 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 \u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\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":"","description_zh_html":"","examples":[{"expr":"parse_ident('\"SomeSchema\".someTable')","result":"{SomeSchema,sometable}"}],"html":"\u003ccode class=\"function\"\u003eparse_ident\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estrict_mode\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 ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-STRING-OTHER","file":"functions-string.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"parse-ident","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"parse_ident","Summary":"将qualified_identifier拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为name[]。","BodyHTML":"将\u003cem\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为\u003ccode\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为\u003ccode\u003ename[]\u003c/code\u003e。\u003cpre\u003eparse_ident ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]\u003c/pre\u003e将\u003cem\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为\u003ccode\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为\u003ccode\u003ename[]\u003c/code\u003e。","SourceRevision":"1b5ca64c","ContentHash":"ca582b8ff51a0e4ff8b07fb3c89cab76556879ef4ba7cc409bc7045dc0fa6dc5","Payload":{"description_zh":"将qualified_identifier拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为name[]。","description_zh_html":"将\u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为\u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","signatures":[{"description_zh":"将qualified_identifier拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为false，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为name[]。","description_zh_html":"将\u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e拆分为一个标识符数组，去除各个标识符的引号。默认情况下，最后一个标识符之后的额外字符被视为错误；但是，如果第二个参数为\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e，则忽略这些额外的字符。（这种行为对于解析类似函数的对象的名称有作用。）请注意，此函数不会截断超长标识符。如果你想截断，你可以将结果转换为\u003ccode class=\"type\"\u003ename[]\u003c/code\u003e。","returns":"text[]","text":"parse_ident ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"afb64c946c2994647dad811b7235d9e2cf16c9912d2dc112ae4a2bdde4cddab7","Text":"parse_ident ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","Returns":"text[]","Payload":{"description":"Splits qualified_identifier 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 \u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\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":"","description_zh_html":"","examples":[{"expr":"parse_ident('\"SomeSchema\".someTable')","result":"{SomeSchema,sometable}"}],"html":"\u003ccode class=\"function\"\u003eparse_ident\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003equalified_identifier\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estrict_mode\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 ( qualified_identifier text [, strict_mode boolean DEFAULT true ] ) → text[]","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}