I was trying to write out data from a table to an xml file, so that I
could export out this file to another external application from another
vendor. I got to export the data based on a predefined schema. I am able
to do this through .NET using c#, but I was wondering if there is way if
I can do this from the database itself.
I would appreciate if you can point me towards/with some examples or links.
Thank you,
Murali.
Chris wrote:
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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
