pgFormatter is a SQL formatter/beautifier which supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, and SQL-2011, and PostgreSQL-specific keywords. It can work as a console program or as a CGI system. It will automatically detect its environment and output as text or as HTML according to the context.
pg_xnode is an extension (module) which adds several data types to the PostgreSQL database server, allowing it to store XML documents, XML (tree) nodes, and XPath expressions. Unlike the in-core implementation of XML, pg_xnode does not require repeated parsing of XML data, and thus should be more efficient. In addition, the extension has functions to add/remove nodes to/from existing XML documents, and templates to create XML documents from tables.