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