On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:
Please go through the documentation listed at:
http://developer.postgresql.org/pgdocs/postgres/functions-xml.html
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
Use the query_to_xml or table_to_xml functions.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
The Enterprise PostgreSQL Company
Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb
