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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to