Postgresql xmlelement query

EABoyd

New Member
I've a query:\[code\]SELECT xmlelement(name Place, Tokyo)\[/code\]and output looks like this:\[code\]<place>Tokyo</place>\[/code\]how to change query to have output like this:\[code\]<n1:place>Tokyo</n1:place>\[/code\]Thanks in advance for help.
 
Back
Top