Postgres Pro
Downloads
Home   >   mailing lists

Thread: Select Output in XML format

Select Output in XML format

From
Adarsh Sharma
Date:
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.

In mysql there is simple query for that :

mysql -X -e "select * from db_name.master"  > /hdd2-1/test.xml

In postgres , i find some XML data types but how we can put our select
output into xml file.


Thanks

Re: Select Output in XML format

From
Craig Ringer
Date:
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

Re: Select Output in XML format

From
Chetan Suttraway
Date:


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

In mysql there is simple query for that :

mysql -X -e "select * from db_name.master"  > /hdd2-1/test.xml

In postgres , i find some XML data types but how we can put our select output into xml file.


Thanks

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Please go through below link:

http://www.postgresql.org/docs/9.0/static/xml2.html
http://developer.postgresql.org/pgdocs/postgres/functions-xml.html

Regards,
Chetan

--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

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




Re: Select Output in XML format

From
Adarsh Sharma
Date:
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

Re: Select Output in XML format

From
Chetan Suttraway
Date:


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

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




Re: Select Output in XML format

From
Chetan Suttraway
Date:


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



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



--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

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