Returning XML with SELECT statements? IS THIS POSSIBLE?

From: Ryan Griggs <ryan(dot)griggs(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Returning XML with SELECT statements? IS THIS POSSIBLE?
Date: 2005-09-09 16:56:12
Message-ID: OCEBKBFANNGJLIOGNHMBEEIJCOAA.rgriggs@hilltop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I desire to develop an XML-based web application which interfaces with a
backend PostgreSQL database.
Is there any way to instruct the SELECT statements to return results as XML
rather than a dataset? Microsoft SQL Server uses the “for xml auto” option
to return XML results.

Thank you for information on this issue!

Ryan Griggs
ryan(dot)griggs(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2005-09-09 17:53:39 to_ascii, or some other form of magic transliteration
Previous Message Jim Buttafuoco 2005-09-09 16:37:15 Re: Route Miles