pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
xml 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