Re: xml output.

From: "Murali K(dot) Maddali" <maddalimurali(at)gmail(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: xml output.
Date: 2006-03-21 04:01:14
Message-ID: 441F7A8A.9070505@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vlad 2006-03-21 05:29:40 "libpq.lib"
Previous Message Chris 2006-03-21 02:35:57 Re: xml output.