From: | Mike Rylander <mrylander(at)gmail(dot)com> |
---|---|
To: | Charlotte Pollock <c(dot)pollock(at)bangor(dot)ac(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Exporting to XML |
Date: | 2005-03-22 12:37:48 |
Message-ID: | b918cf3d0503220437776c933b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 22 Mar 2005 11:44:00 +0000, Charlotte Pollock
<c(dot)pollock(at)bangor(dot)ac(dot)uk> wrote:
> 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.
Bibliographic(esqe) data, eh? See my sig. :)
>
> Any suggestions on what might be a good way to tackle this problem,
> gratefully recieved
>
It depends on how the data is structured in the DB (I'm storing
MARCXML, myself) but I would suggest using a perl script with a
Template Toolkit template if you are normalizing the DC-type data on
input.
--
Mike Rylander
mrylander(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-03-22 12:41:50 | Re: Constraint problem |
Previous Message | Richard Huxton | 2005-03-22 12:34:38 | Re: grant problem |