Обсуждение: xml output.
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. Thank you, Murali.
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/
Can I use pl/pgsql or pl/tcl to write function to do that. Murali. 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. >
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/
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. >>> > >