On Thu, Sep 8, 2011 at 12:11 PM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
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
The Enterprise PostgreSQL Company
Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb
