pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nikolay Samokhvalov <samokhvalov@gmail.com>
To: samira khansha <khonshas@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: postgresql and XML
Date: Sun, 4 Mar 2007 21:31:41 +0300
Message-ID: <e431ff4c0703041031j692e26afh421b0b5c0d53f9bf@mail.gmail.com> (raw)
In-Reply-To: <233247.7998.qm@web57106.mail.re3.yahoo.com>
References: <233247.7998.qm@web57106.mail.re3.yahoo.com>

On 3/4/07, samira khansha <khonshas@yahoo.com> wrote:
> hi
> i have a question about postgresql and XML.
> how can i show the result of a postgresql query in a XML document?
> does postgresql support XML?
> thanks a lot

Upcoming version (8.3) will provide several ways for relational-to-XML
mapping (SQL/XML publishing functions, XML export functions, etc).
Currently (<=8.2), all we have is contrib/xml2, which provides XPath
and XSLT functions for text/varchar values. So, if you want to act
now, you should consider implementation of relational-to-XML mappings
on application side (e.g., XML docs publishing could be implemented by
means of some templating engine).

-- 
Best regards,
Nikolay



view thread (2+ messages)

Message-ID: <e431ff4c0703041031j692e26afh421b0b5c0d53f9bf@mail.gmail.com>
Permalink:  ../e431ff4c0703041031j692e26afh421b0b5c0d53f9bf@mail.gmail.com/
Also on:    postgresql.org/message-id/e431ff4c0703041031j692e26afh421b0b5c0d53f9bf@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: samokhvalov@gmail.com, khonshas@yahoo.com
  Subject: Re: postgresql and XML
  In-Reply-To: <e431ff4c0703041031j692e26afh421b0b5c0d53f9bf@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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