Exporting to XML

From: Charlotte Pollock <c(dot)pollock(at)bangor(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Exporting to XML
Date: 2005-03-22 11:44:00
Message-ID: AEFB3420-9AC7-11D9-ACAD-000A956C3B16@bangor.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I want to export data from my postgres database.

I want to output, for each record, a folder containing an XML file eg
<dublin_core>
<dcvalue element="contributor"
qualifier="author">Pollock, Charlotte</dcvalue>
<dcvalue element="identifier"
qualifier="isbn">asdasdasdasd</dcvalue>
<dcvalue element="title" qualifier="none">Our
Publication</dcvalue>
<dcvalue element="type" qualifier="none">Book</dcvalue>
</dublin_core>

each folder (and the xml file contained within it) will contain data
for only one record from the database.

Any suggestions on what might be a good way to tackle this problem,
gratefully recieved

Thanks
Charlie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-03-22 11:51:25 Re: pl/perl problem
Previous Message Richard Huxton 2005-03-22 11:40:41 Re: pl/perl problem