PSQL suggested enhancement - Mailing list pgsql-general

From Dean Gibson (DB Administrator)
Subject PSQL suggested enhancement
Date
Msg-id 4357303B.5020306@ultimeth.com
Whole thread Raw
Responses Re: PSQL suggested enhancement
List pgsql-general
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


pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: server , client encoding issue
Next
From: CSN
Date:
Subject: NULL != text ?