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@gmail.com>I'm confused by the deprecation notice on xml2 seen here.
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