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. Suggested format:
<row>
<field-1-name>field-1 value</field-1-name>
<field-2-name>field-2 value</field-2-name>
</row>
etc. The user would be responsible for adding the enclosing XML.
NULL values could be output as <field-n-name />
Optionally, tags could contain an attribute describing the field type.
Or is there a way to do this I don't know about?
-- Dean