pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedxml output
4+ messages / 4 participants
[nested] [flat]
* xml output
@ 2003-07-11 13:08 stephane parenton <stephane@parenton.com>
2003-07-12 10:10 ` Re: xml output weigelt@metux.de
0 siblings, 1 reply; 4+ messages in thread
From: stephane parenton @ 2003-07-11 13:08 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: xml output
2003-07-11 13:08 xml output stephane parenton <stephane@parenton.com>
@ 2003-07-12 10:10 ` weigelt@metux.de
0 siblings, 0 replies; 4+ messages in thread
From: weigelt@metux.de @ 2003-07-12 10:10 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* XML output ?
@ 2007-08-31 03:51 Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
2007-09-01 23:48 ` Re: XML output ? Peter Koczan <pjkoczan@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Khan, Mahmood Ahram @ 2007-08-31 03:51 UTC (permalink / raw)
To: pgsql-admin; pgsql-admin-owner@postgresql.org; tgl@sss.pgh.pa.us
Hi All,
Is it possible to generate the output of SQL statements in PostgreSQL to
XML output?
If anybody has came across with this or worked on it? Or anybody has any
Documentation for that.
Thanks & Regards
M.AHRAM KHAN
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: XML output ?
2007-08-31 03:51 XML output ? Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
@ 2007-09-01 23:48 ` Peter Koczan <pjkoczan@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Koczan @ 2007-09-01 23:48 UTC (permalink / raw)
To: Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org; tgl@sss.pgh.pa.us
> Is it possible to generate the output of SQL statements in PostgreSQL to XML
> output?
>
> If anybody has came across with this or worked on it? Or anybody has any
> Documentation for that?
Yes, you can either install the xml2 contrib module for current
versions, or if you can hold out until 8.3, there will be functions
for xml output built into postgres.
Check out http://developer.postgresql.org/pgdocs/postgres/functions-xml.html
and http://developer.postgresql.org/pgdocs/postgres/datatype-xml.html
for the upcoming 8.3 stuff. I couldn't find anything on xml2 quickly,
but I'm sure a few minutes of searching will help you find what you
need.
Peter
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-09-01 23:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-11 13:08 xml output stephane parenton <stephane@parenton.com>
2003-07-12 10:10 ` weigelt@metux.de
2007-08-31 03:51 XML output ? Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
2007-09-01 23:48 ` Re: XML output ? Peter Koczan <pjkoczan@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox