From: | "Rishabh Gupta" <rg117(at)york(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org |
Subject: | postgresql query to XML result |
Date: | 2002-04-20 21:01:13 |
Message-ID: | a9sktm$6ol$1@pump1.york.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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>CD TITLE</TITLE>
<ARTISTS>
<ARTIST>artist1</ARTIST>
<ARTIST>artist2</ARTIST>
<ARTIST>artist3</ARTIST>
<ARTIST>artist4</ARTIST>
</ARTISTS>
<TRACKS>
<TRACK>Track Title 1</TRACK>
<TRACK>Track Title 2</TRACK>
<TRACK>Track Title 3</TRACK>
<TRACK>Track Title 4</TRACK>
<TRACK>Track Title 5</TRACK>
</TRACKS>
</CD>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-20 22:40:59 | Re: MacOS X and external functions |
Previous Message | Devrim GUNDUZ | 2002-04-20 19:07:14 | Seminar reports from Turkey |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-04-21 04:45:04 | Re: accept AD35- 6FA9 -9515 |
Previous Message | Rajesh Kumar Mallah | 2002-04-20 19:00:37 | OpenFTS/tsearch and Postgresql 7.2.1 |