If you are running PostgreSQL version 7.2.x, you can
install pl/perlu ("untrusted" Perl procedural
language), which will allow you to use any Perl module
that will do what you want.
Sorry, don't know enough about the modules to
recommend one in particular.
--- Evgeniy Strokin <evgeniy_strokin@yahoo.com> wrote:
> Hmmm, I don�t think generate XML from recordset on
> application side is better solution, than XML
> generating on SQLServer side.
> And there are no such tools (Java) and standards yet
> as far as I know.
> Anyway, I get the answer, Thanks for respond.
>
> Jenya
>
> --- Jeff Davis <list-pgsql-general@empires.org>
> wrote:
> > I don't think postgres has any routines to
> generate
> > xml. You might look into
> > your application language; most have quite
> extensive
> > xml libraries. There
> > might be some better support in the future, but
> it's
> > primarily an
> > application's job to do that kind of thing.
> >
> > Regards,
> > Jeff
> >
> > On Wednesday 15 May 2002 06:58 am, Evgeniy Strokin
> > wrote:
> > > Hi,
> > > Does PostgreSQL generate XML?
> > > I need get result of query not like recordset
> but
> > like
> > > XML (probably XML will be in recordset but it�s
> > ok).
> > > If it doesn�t support now may be some plans for
> > > future?
> > > Thanks
> > > Jenya
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > LAUNCH - Your Yahoo! Music Experience
> > > http://launch.yahoo.com
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com