Re: PSQL suggested enhancement

Patrick TJ McPhee schrieb:
> In article <DB28E9B548192448A4E8C8A3C1B1E475611D89(at)sj1-exch-01(dot)us(dot)corp(dot)kailea(dot)com>,
> Roger Hand <RHand(at)kailea(dot)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...