Re: Select Output in XML format

On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>wrote:

> Thanks I am trying as below ;
>
>
> db_name=# select table_to_xml(tbl master, nulls boolean, tableforest
> boolean, targetns text);
> ERROR: syntax error at or near "master"
> LINE 1: select table_to_xml(tbl master, nulls boolean, tableforest b...
> ^
> Do I need to use both functions
>
>
>
Please go through the documentation listed at:

http://developer.postgresql.org/pgdocs/postgres/functions-xml.html

>
> Craig Ringer wrote:
>
>> 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<http://www.postgresql.org/docs/current/static/functions-xml.html>
>>
>> Use the query_to_xml or table_to_xml functions.
>>
>> --
>> Craig Ringer
>>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>

--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb