xml output.

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:

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: