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/