Re: XML ouput for psql

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073