Re: Select Output in XML format

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


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
>
> Use the query_to_xml or table_to_xml functions.
>
> --
> Craig Ringer