Re: PSQL suggested enhancement

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...