You can try to use this patch:
http://archives.postgresql.org/pgsql-patches/2005-09/msg00138.php
This is implementation of basic functions of SQL/XML (14th part of
SQL:2003, http://www.sqlx.org/)
I've successfully applied it to 8.1 version - no troubles.
On 11/11/05, Warren Murray <murray_warren@bah.com> wrote:
> What is the process to export a PostgreSQL table to XML? How is it done?
> Thanks!
>
> Warren L Murray
> Booz Allen Hamilton
> Phone: 404.518.7940
> Email: murray_warren@bah.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
Best regards,
Nikolay