Exporting to XML - Mailing list 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