Re: Select Output in XML format

[Chetan Suttraway <chetan.suttraway@xxxxxxxxxxxxxxxx>]

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

Website: www.enterprisedb.com

EnterpriseDB Blog : http://blogs.enterprisedb.com

Follow us on Twitter : http://www.twitter.com/enterprisedb