Thread: xml output

xml output

From
stephane parenton
Date:
Hi, I'm new to postgres and have quickly read the doc, bought a book,
but haven't seen if one can get an xml output from a SQL request....

is it possible to have something like "select blah1 blah2 from mytable1
where blah45=thing12 as xml using formatfile" ?

TIA
stephane



Re: xml output

From
weigelt@metux.de
Date:
On Fri, Jul 11, 2003 at 03:08:19PM +0200, stephane parenton wrote:

hi,

> is it possible to have something like "select blah1 blah2 from mytable1
> where blah45=thing12 as xml using formatfile" ?
no, this belongs to the client - not the server.
you could write an psql replacement which understands this.

cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux ITS
 Webhosting ab 5 EUR/Monat.          UUCP, rawIP und vieles mehr.

 phone:     +49 36207 519931         www:       http://www.metux.de/
 fax:       +49 36207 519932         email:     contact@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/