Postgresql xmlelement query

Question

I've a query:

SELECT xmlelement(name Place, Tokyo)

and output looks like this:

<place>Tokyo</place>

how to change query to have output like this:

<n1:place>Tokyo</n1:place>

Thanks in advance for help.

Peter Eisentraut · Accepted Answer · 2013-03-20 20:07:11Z

1

XML namespaces are not (yet) supported in XMLELEMENT.

You will have to do this by some sort of postprocessing, perhaps using XSLT.

answered Mar 20, 2013 at 20:07

Peter Eisentraut

37.1k12 gold badges91 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1