On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma
<adarsh.sharma@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
Check the below syntax:
--already created base table
pg=# desc base;
Table "public.base"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Number of child tables: 1 (Use \d+ to list them.)
pg=# select table_to_xml( 'base', true, true, '');
table_to_xml
--------------------------------------------------------------
<base xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance">+
+
<a>1</a> +
</base> +
+
<base xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance">+
+
<a>2</a> +
</base> +
+
(1 row)
--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company