Re: XML ouput for psql

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I like the idea of doing XML in psql --- it seems like a natural place
> > for it.
>
> Not really; what of applications other than shell scripts that would
> like to get XML-formatted output?
>
> There was some talk in the FE/BE protocol thread of adding hooks to
> support more than one output format from the backend. Much of the
> infrastructure already exists (see DestReceiver in the backend); we
> just need an agreement on the protocol. On the whole I'd rather see
> it done that way than burying the logic in psql.

Well, programs can run psql using popen. It seems overkill to get the
protocol involved, specially since it is output-only. I can't imagine
who would bother with the wire protocol messiness just to get xml.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073