Re: XML export function signatures

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tommy Gildseth <tommy(at)gildseth(dot)com>
Subject: Re: XML export function signatures
Date: 2007-02-12 23:58:36
Message-ID: 200702130058.37099.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tommy Gildseth wrote:
> How do you define the table name when fetching data using a join,
> union etc. where the data doesn't necessarily originate from a single
> table?

If you use the query_to_xml function, then I just write "<table>"
without any particular name.

> Another neat feature would be if you could specify a set of columns
> which should be represented as attributes instead of nodes.

I'm sure there are plenty of possible neat features, but most of these
can be implemented by passing the result through an XSLT
transformation.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chad Wagner 2007-02-13 00:00:29 Re: Acclerating INSERT/UPDATE using UPS
Previous Message Jeremy Drake 2007-02-12 23:31:50 Re: pgsql: Fix backend crash in parsing incorrect tsquery.