生成Xml结构 [英] generating Xml structure

问题描述

Hello House，请问有谁知道从PostgreSql生成XML结构的语法？在SQL服务器中我使用这样的东西：SELECT receiptno，retype，make FROM FROM for AUTO AUTO，Elements;但我不知道如何在PostgreSql中做到这一点。在此先感谢。

解决方案

试试这个...... :)



http://www.postgresql.org/docs/9.2/static/datatype-xml.html [<一个href =http://www.postgresql.org/docs/9.2/static/datatype-xml.html\"target =_ blanktitle =新窗口> ^ ]



http://www.postgresql.org/docs/devel /static/functions-xml.html [ ^ ]

Hello House, please does anyone know the syntax for generating XML structure from PostgreSql? in SQL server i use something like this: SELECT receiptno,retype,make FROM receipt for XML AUTO, Elements; but i dont know how to do it in PostgreSql. Thanks in advance.

解决方案

Try this...:)

http://www.postgresql.org/docs/9.2/static/datatype-xml.html[^]

http://www.postgresql.org/docs/devel/static/functions-xml.html[^]

这篇关于生成Xml结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！