X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D970BDBBBE for ; Sat, 19 Nov 2005 08:27:28 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13130-10 for ; Sat, 19 Nov 2005 12:27:30 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.207]) by svr1.postgresql.org (Postfix) with ESMTP id D9A5BDBB69 for ; Sat, 19 Nov 2005 08:27:25 -0400 (AST) Received: by xproxy.gmail.com with SMTP id i30so352100wxd for ; Sat, 19 Nov 2005 04:27:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=a31jhIjjIwQQXsx1Yh0Vydcs5C1SlKPR2sWpW5D+WS7aifAoFfN0mI+gqetco2Bt5bEPZh1ZNfmYlZL/mhXxeWv0HX2kkIBW0nxrNBrq/oDanXceKcXqcvzGVnW6fZnazyhdKJij8M6gt+t0oTmJxSANcR7LVrUMb4q+Pr4yHV0= Received: by 10.70.69.1 with SMTP id r1mr643592wxa; Sat, 19 Nov 2005 04:27:29 -0800 (PST) Received: by 10.70.104.2 with HTTP; Sat, 19 Nov 2005 04:27:29 -0800 (PST) Message-ID: Date: Sat, 19 Nov 2005 15:27:29 +0300 From: Nikolay Samokhvalov Reply-To: nikolay@samokhvalov.com To: Warren Murray , pgsql-sql@postgresql.org Subject: Re: Export to XML In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/158 X-Sequence-Number: 23409 You can try to use this patch: http://archives.postgresql.org/pgsql-patches/2005-09/msg00138.php This is implementation of basic functions of SQL/XML (14th part of SQL:2003, http://www.sqlx.org/) I've successfully applied it to 8.1 version - no troubles. On 11/11/05, Warren Murray wrote: > What is the process to export a PostgreSQL table to XML? How is it done? > Thanks! > > Warren L Murray > Booz Allen Hamilton > Phone: 404.518.7940 > Email: murray_warren@bah.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Best regards, Nikolay