if you want to export the data in xml type
i suggest you to use the EMS SQL Manager for PostgreSQL
because
you can export the whole table or an executed query in many different file
types including xml
2011/3/23 Rob Sargent <robjsargent(at)gmail(dot)com>
> I'm confused by the deprecation notice on xml2 seen here<http://www.postgresql.org/docs/9.0/interactive/xml2.html>
> .
>
> What if anything was removed in the making of 8.4? Was the newer standard
> API implemented? Do I still need namespaces?
>
> I'm running PostgreSQL 9.0.3 built locally with --with-libxml. Which
> version, w.r.t. to the deprecation, might I be using.
>
> rjs
>
>