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/