Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id E98A947511A; Sat, 20 Apr 2002 17:35:13 -0400 (EDT) Received: from jupiter.hub.org (localhost [127.0.0.1]) by jupiter.hub.org (8.12.3/8.12.3) with ESMTP id g3KLZF8q029218; Sat, 20 Apr 2002 16:35:15 -0500 (CDT) (envelope-from news@jupiter.hub.org) Received: (from news@localhost) by jupiter.hub.org (8.12.3/8.12.3/Submit) id g3KLTOIw029014; Sat, 20 Apr 2002 16:29:24 -0500 (CDT) From: "Rishabh Gupta" X-Newsgroups: comp.databases.postgresql.questions, comp.databases.postgresql.sql, comp.text.xml Subject: postgresql query to XML result Date: Sat, 20 Apr 2002 22:01:13 +0100 Organization: The University of York, UK Lines: 42 Message-ID: X-Complaints-To: abuse@york.ac.uk X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200204/894 X-Sequence-Number: 23608 Hi all, Can anyone tell me whether there is any querying system that allows query results to be output in XML. The data that I am dealing with is ordinary relation data, so this is not a question on how to store XML documents into postgresql. I am not trying to save XML documents into the DB. What I would like is if I could run an SQL-like query and the output would be an XML document. E.g. suppose I have a database of Music CDS, there would be a table for the CD, a table for the Artist, a table for the Track. There would be further tables to join them together, e.g. CD_Artist and CD_Track. The output of a query would be something like this: CD TITLE artist1 artist2 artist3 artist4 Track Title 1 Track Title 2 Track Title 3 Track Title 4 Track Title 5 I have had a look at LXP but I would prefer something that sits closer to the actual DBMS. As I understand it, LXP is a scripting language that is executed by Apache. Does anyone know of such a system. Your help would be greatly appreciated. Many Thanks Rishabh