{"Entry":{"collection":"func","key":"xmlelement","name":"xmlelement","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.2","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.3"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"a20e4f0580c0c8d263fba855a3ea026034106b9aad4707f39f7da05a3ec68ad9","first_version":"8.3","group":"xml","group_label":"Xml Functions","groups":["xml"],"imported_at":"2026-09-27T17:57:28.799408+08:00","last_version":"20","name":"xmlelement","name_key":"xmlelement","position":15020,"present_in":["8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"xmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml","signature_count":1,"slug":"xmlelement","source_rev":"b7bd9cda","summary":"The xmlelement expression produces an XML element with the given name, attributes, and content.","summary_zh":""}},"Definition":{"Collection":"func","Key":"xmlelement","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"xmlelement","SourceRevision":"b7bd9cda","Facts":{"description":"The xmlelement expression produces an XML element with the given name, attributes, and content. The name and attname items shown in the syntax are simple identifiers, not values. The attvalue and content items are expressions, which can yield any PostgreSQL data type. The argument(s) within XMLATTRIBUTES generate attributes of the XML element; the content value(s) are concatenated to form its content.","description_html":"The \u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e expression produces an XML element with the given name, attributes, and content. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e items shown in the syntax are simple identifiers, not values. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e items are expressions, which can yield any \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e data type. The argument(s) within \u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e generate attributes of the XML element; the \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e value(s) are concatenated to form its content.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-PRODUCING-XML-XMLELEMENT","file":"functions-xml.html","slug":"18"},"group":"xml","group_label":"Xml Functions","lang":"en","layout":"table-new","pages":["functions-xml.html"],"prose_only":false,"signatures":[{"description":"The xmlelement expression produces an XML element with the given name, attributes, and content. The name and attname items shown in the syntax are simple identifiers, not values. The attvalue and content items are expressions, which can yield any PostgreSQL data type. The argument(s) within XMLATTRIBUTES generate attributes of the XML element; the content value(s) are concatenated to form its content.","description_html":"The \u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e expression produces an XML element with the given name, attributes, and content. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e items shown in the syntax are simple identifiers, not values. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e items are expressions, which can yield any \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e data type. The argument(s) within \u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e generate attributes of the XML element; the \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e value(s) are concatenated to form its content.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eNAME\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e, \u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eAS\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, ...\u003c/span\u003e] ) \u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e, ...\u003c/span\u003e]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-PRODUCING-XML-XMLELEMENT","file":"functions-xml.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmlelement","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"xmlelement","Summary":"表达式xmlelement使用给定名称、属性和内容产生一个 XML 元素。语法中显示的name和attname项是简单的标识符，而不是值。attvalue和content项是表达式，它们可以产生任意PostgreSQL数据类型的值。XMLATTRIBUTES的参数生成XML元素的属性；将content值连接起来形成其内容。","BodyHTML":"表达式\u003ccode\u003exmlelement\u003c/code\u003e使用给定名称、属性和内容产生一个 XML 元素。语法中显示的\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e项是简单的标识符，而不是值。\u003cem\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e项是表达式，它们可以产生任意\u003cspan\u003ePostgreSQL\u003c/span\u003e数据类型的值。\u003ccode\u003eXMLATTRIBUTES\u003c/code\u003e的参数生成XML元素的属性；将\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e值连接起来形成其内容。\u003cpre\u003exmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml\u003c/pre\u003e表达式\u003ccode\u003exmlelement\u003c/code\u003e使用给定名称、属性和内容产生一个 XML 元素。语法中显示的\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e项是简单的标识符，而不是值。\u003cem\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e项是表达式，它们可以产生任意\u003cspan\u003ePostgreSQL\u003c/span\u003e数据类型的值。\u003ccode\u003eXMLATTRIBUTES\u003c/code\u003e的参数生成XML元素的属性；将\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e值连接起来形成其内容。","SourceRevision":"ca936764","ContentHash":"3c1765148d799042e4e70357aa21948f389b24ff88a17df7716c5117a05b69a0","Payload":{"description_zh":"表达式xmlelement使用给定名称、属性和内容产生一个 XML 元素。语法中显示的name和attname项是简单的标识符，而不是值。attvalue和content项是表达式，它们可以产生任意PostgreSQL数据类型的值。XMLATTRIBUTES的参数生成XML元素的属性；将content值连接起来形成其内容。","description_zh_html":"表达式\u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e使用给定名称、属性和内容产生一个 XML 元素。语法中显示的\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e和\u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e项是简单的标识符，而不是值。\u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e和\u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e项是表达式，它们可以产生任意\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e数据类型的值。\u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e的参数生成XML元素的属性；将\u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e值连接起来形成其内容。","signatures":[{"description_zh":"表达式xmlelement使用给定名称、属性和内容产生一个 XML 元素。语法中显示的name和attname项是简单的标识符，而不是值。attvalue和content项是表达式，它们可以产生任意PostgreSQL数据类型的值。XMLATTRIBUTES的参数生成XML元素的属性；将content值连接起来形成其内容。","description_zh_html":"表达式\u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e使用给定名称、属性和内容产生一个 XML 元素。语法中显示的\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e和\u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e项是简单的标识符，而不是值。\u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e和\u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e项是表达式，它们可以产生任意\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e数据类型的值。\u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e的参数生成XML元素的属性；将\u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e值连接起来形成其内容。","returns":"xml","text":"xmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"d5921fb5fa9b55045eac3a2be81c611cc121739830f64abac1ecf203ef840bd2","Text":"xmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml","Returns":"xml","Payload":{"description":"The xmlelement expression produces an XML element with the given name, attributes, and content. The name and attname items shown in the syntax are simple identifiers, not values. The attvalue and content items are expressions, which can yield any PostgreSQL data type. The argument(s) within XMLATTRIBUTES generate attributes of the XML element; the content value(s) are concatenated to form its content.","description_html":"The \u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e expression produces an XML element with the given name, attributes, and content. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e items shown in the syntax are simple identifiers, not values. The \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e items are expressions, which can yield any \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e data type. The argument(s) within \u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e generate attributes of the XML element; the \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e value(s) are concatenated to form its content.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlelement\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eNAME\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e, \u003ccode class=\"literal\"\u003eXMLATTRIBUTES\u003c/code\u003e ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattvalue\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eAS\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattname\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, ...\u003c/span\u003e] ) \u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"replaceable\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e, ...\u003c/span\u003e]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlelement ( NAME name [, XMLATTRIBUTES ( attvalue [AS attname] [, ...] ) ] [, content [, ...]] ) → xml","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}