get_xml is a module that contains a function that allows you to publish any query result as an XML document.
The get_xmlproject is a PostgreSQL Community project that is a part of the pgFoundry.
The pgFoundry page for the project is at http://pgfoundry.org/projects/getxml, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.