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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
