Re: postgresql and XML

["Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>]

On 3/4/07, samira khansha <khonshas(at)yahoo(dot)com> wrote:
> hi
> i have a question about postgresql and XML.
> how can i show the result of a postgresql query in a XML document?
> does postgresql support XML?
> thanks a lot

Upcoming version (8.3) will provide several ways for relational-to-XML
mapping (SQL/XML publishing functions, XML export functions, etc).
Currently (<=8.2), all we have is contrib/xml2, which provides XPath
and XSLT functions for text/varchar values. So, if you want to act
now, you should consider implementation of relational-to-XML mappings
on application side (e.g., XML docs publishing could be implemented by
means of some templating engine).

--
Best regards,
Nikolay