Re: Select Output in XML format

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Select Output in XML format
Date: 2011-09-08 07:12:51
Message-ID: 4E686AF3.5090907@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/09/2011 2:41 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I need to write the output of an postgres table into XML format.
> I think there is an easiest way to do this but not able to find it.

http://www.postgresql.org/docs/current/static/functions-xml.html

Use the query_to_xml or table_to_xml functions.

--
Craig Ringer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chetan Suttraway 2011-09-08 07:14:08 Re: Select Output in XML format
Previous Message Fujii Masao 2011-09-08 07:00:59 Re: master-side counterpart of pg_last_xact_replay_timestamp?