Re: PSQL suggested enhancement - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: PSQL suggested enhancement
Date
Msg-id 4358F95C.7060309@wildenhain.de
Whole thread Raw
In response to Re: PSQL suggested enhancement  (ptjm@interlog.com (Patrick TJ McPhee))
List pgsql-general
Patrick TJ McPhee schrieb:
> In article <DB28E9B548192448A4E8C8A3C1B1E475611D89@sj1-exch-01.us.corp.kailea.com>,
> Roger Hand <RHand@kailea.com> wrote:
>
> % If pg outputs a simple xml format, it can easily be transformed via xslt
> % into OpenDoc table format, alternate html formats, or the alternate xml
> % format of your choice.
>
> Well, pg does output a simple xml format, which can be transformed via
> xslt, and yet here's a suggestion for an enhancement to do it differently.
> To be more explicit, if you turn on html output and turn off the footer
>
>  \H
>  \pset footer off
>
> what you get isn't always valid HTML, but it does seem to be well-formed XML,
> which can be easily transformed to the XML you really want.

not 100% true because the type information is missing here.

Otoh, if one has a spreadsheet program one can just fetch the
data directly from database into it...



pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: password
Next
From: Tom Lane
Date:
Subject: Re: Strange order of execution with rule