> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Michael > Glaesemann > Sent: Wednesday, October 19, 2005 11:24 PM > On Oct 20, 2005, at 14:50 , Dean Gibson (DB Administrator) wrote: >> PSQL has the option to output the result of queries in several >> different formats, including HTML. Suggestion: have an option to >> output query results in XML format. > > My personal opinion on this is that there are a lot of different > ideas about how the XML should/could be written, and a the current > output can be piped to a script in <insert favorite scripting > language here> to format to match anyone's wish. Rather than have > psql decree the one and true format or include so many as to make > maintainability burdensome, further formatting is best left to the > end user. By that reasoning there shouldn't be html format either. The beauty of xml output is that it can easily be processed via xslt to create whatever format the user wants. So there need not be "one true format" but simply one root format that could be easily transformed. -Roger > Michael Glaesemann ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
