Murali K. Maddali wrote:
Can I use pl/pgsql or pl/tcl to write function to do that.

Can't see why not (I'm sure others will chime in if it's not possible or not a good idea) but that's not going to help for a full database dump. Doing a set of results it should work ok though. Depends what you need the xml for.


Chris wrote:

Murali K. Maddali wrote:

Hello Guys,

I am trying to export the data out of the database directly to an xml file. Is there a way that I could do this in PostgreSQL. I am looking for a function or something like that. Does PostgreSQL support sqlxml.


Don't think so. A small script (perl, python, ruby, whatever) should be able to convert it easily enough though.



--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to