On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma <adarsh.sha...@orkash.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@postgresql.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
