Re: PSQL suggested enhancement - Mailing list pgsql-general

From Roger Hand
Subject Re: PSQL suggested enhancement
Date
Msg-id DB28E9B548192448A4E8C8A3C1B1E475611D88@sj1-exch-01.us.corp.kailea.com
Whole thread Raw
In response to PSQL suggested enhancement  ("Dean Gibson (DB Administrator)" <postgresql4@ultimeth.com>)
Responses Re: PSQL suggested enhancement  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: NULL != text ?
Next
From: Michael Glaesemann
Date:
Subject: Re: PSQL suggested enhancement