From khonshas@yahoo.com Sun Mar 4 08:44:41 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 830559FA667 for ; Sun, 4 Mar 2007 04:44:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 02318-03 for ; Sun, 4 Mar 2007 04:44:35 -0400 (AST) X-Greylist: delayed 00:06:40.642183 by SQLgrey-1.7.4 Received: from web57106.mail.re3.yahoo.com (web57106.mail.re3.yahoo.com [216.252.111.119]) by postgresql.org (Postfix) with SMTP id E830D9FA49F for ; Sun, 4 Mar 2007 04:44:37 -0400 (AST) Received: (qmail 8818 invoked by uid 60001); 4 Mar 2007 08:37:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=45UJcwQoUIopCfQONYGPbOmPLCFTodVjELha55vIUQH6/BdWvYOTqVFpy9M67pJ7Umz8VtPuZmsJdoAd6ih/syogVw3I01yjh201WgNsIrufwgvYZmYfVb+deKPC/aR4QLHrrgVu7MPMmJz6XfGaQG3TX2FcWFT6t15R/deJDtQ=; X-YMail-OSG: k_jxLkIVM1kk8NE_w0Z_cZ9YQw1ePma7y.fJ05Qq_nvrD8T6zzjU2nyvFNtw9mLUnkRGaMjSSO2dVaTGkyP1m7wEcZmahRtv1Oqq17kfxemlqTt4Dwr56KdNZPnq6r0LZ7v3nnWFxeoPM9pQpUo2SD3zag-- Received: from [80.191.123.138] by web57106.mail.re3.yahoo.com via HTTP; Sun, 04 Mar 2007 00:37:56 PST Date: Sun, 4 Mar 2007 00:37:56 -0800 (PST) From: samira khansha Subject: postgresql and XML To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1722788185-1172997476=:7998" Content-Transfer-Encoding: 8bit Message-ID: <233247.7998.qm@web57106.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.305 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_50_60, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200703/11 X-Sequence-Number: 6452 --0-1722788185-1172997476=:7998 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --------------------------------- Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. --0-1722788185-1172997476=:7998 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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

Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos. --0-1722788185-1172997476=:7998-- From samokhvalov@gmail.com Sun Mar 4 18:31:45 2007 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