Обсуждение: Export table/view in xml-format
Hi, is there a tool to export contents of a table or view in xml? I would like something that: --- cut --- <xml-header> bla and blub </xml-header> <tablename> <row> <column_a>data</column_a> <column_b>data</column_b>. ... </row> <row> <column_a>data</column_a> <column_b>data</column_b> ... </row> </tablename> <xml-footer> some text </xml-footer> --- cut --- ciao Detlef -- # Dipl. Ing. (FH) Detlef Jockheck # E-mail: detlef@jockheck.de # -------------------------------
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > is there a tool to export contents of a table or view in xml? I would like > something that: There is some current discusion about having a switch in psql that would enable this. I wrote a patch that does just this: see the link below. Note that it was made against CVS tip (as of around 2 weeks ago) and will probably not be identical to the final version. However, it should do what you asked for. http://groups.google.com/groups?q=psql+XML&oe=UTF-8&selm=b9daa33f80cc0a0c73d984696cb8fbac%40biglumber.com You can also look at the perl module DBIx:XML, which produces very similar results: http://search.cpan.org/author/MSERGEANT/DBIx-XML_RDB-0.05/XML_RDB.pm - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200303100919 -----BEGIN PGP SIGNATURE----- Comment: http://www.turnstep.com/pgp.html iD8DBQE+bKE2vJuQZxSWSsgRAsPIAJ9yZvGZoso4e5tf9fvxb/vUZXSqhgCcCKka KhbIsi+5qz+KaFrtHEYEYOA= =tI9M -----END PGP SIGNATURE-----