Postgres Pro
Downloads
Home   >   mailing lists

Re: Select Output in XML format - Mailing list pgsql-general

From Craig Ringer
Subject Re: Select Output in XML format
Date
Msg-id 4E686AF3.5090907@ringerc.id.au
Whole thread Raw
In response to Select Output in XML format  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Responses Re: Select Output in XML format
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Fujii Masao
Date:
Subject: Re: master-side counterpart of pg_last_xact_replay_timestamp?
Next
From: Chetan Suttraway
Date:
Subject: Re: Select Output in XML format