Re: xml output.

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.
>>>
>
>