Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 226039FB4F8 for ; Sun, 4 Mar 2007 14:31:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 32786-01 for ; Sun, 4 Mar 2007 14:31:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by postgresql.org (Postfix) with ESMTP id 7AA4B9FB36C for ; Sun, 4 Mar 2007 14:31:42 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i31so1213940wra for ; Sun, 04 Mar 2007 10:31:41 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cGQahBcMDBdsMHQQDtxQOpVb3plx8Pv7UY4Vp4CRCjNTswXgUri/npcl8QPHaXmOC4JzJaiAHxthZlW2RS0fTtTiWkeoGz9vDzqwz2L0f7Klp3jdLLPfMQuB+XppNBy/wV6IAqZS5ItkwSWY2JVnbeKNHNoKIwnOi/Lcub1jI04= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=pKoLBtBWvEd8vvaSsZW5fa2GrxBE9hPMZxm1h9HDs+DPio0acTGOfyY8RNPItJpg5UXOKl8lg170ott312SwuoFPMQ/Yuem8epRo0HNAMhtSp6QW3uv2K2ki64w9N/D02ki+X69PvEDlYIwiiRdPD6kj6kgwDera/C5UhXtXTvE= Received: by 10.114.205.1 with SMTP id c1mr980956wag.1173033101295; Sun, 04 Mar 2007 10:31:41 -0800 (PST) Received: by 10.114.157.15 with HTTP; Sun, 4 Mar 2007 10:31:41 -0800 (PST) Message-ID: Date: Sun, 4 Mar 2007 21:31:41 +0300 From: "Nikolay Samokhvalov" Reply-To: nikolay@samokhvalov.com To: "samira khansha" Subject: Re: postgresql and XML Cc: pgsql-interfaces@postgresql.org In-Reply-To: <233247.7998.qm@web57106.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <233247.7998.qm@web57106.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/13 X-Sequence-Number: 6454 On 3/4/07, samira khansha 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