From: | Enrico Oliva <oliva(dot)enrico(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | xmlElement and \n |
Date: | 2013-09-19 07:46:51 |
Message-ID: | CAG4yfC6ryLfRBUr+J=cDJuUAzQQLxF+Rudde9+5GhFXK6zEEzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi, I would like to have a output xml file with the carriage return at the
end of each element.
COPY(
select xmlelement(name "IDXS",XMLAGG(xml_task_group))
from (select i.relname as IDX,
xmlelement(name "IDX",XMLATTRIBUTES(i.relname as "name"),
xmlelement(name "IDX_IS_UNIQUE",CASE WHEN ix.indisunique THEN 'Yes'
ELSE 'No' END ),
xmlelement(name "IDX_IS_PRIMARY_KEY",CASE WHEN ix.indisprimary THEN
'Yes' ELSE 'No' END),
xmlelement(name "IDX_COLUMNS",xmlagg(xmlelement(name
"IDX_COLUMN",a.attname)))) as xml_task_group
from
....
) TO 'proteoIndes.xml'
The result is in only one text raw:
<IDXS><IDX
name="as001_c01pk"><IDX_IS_UNIQUE>Yes</IDX_IS_UNIQUE><IDX_IS_PRIMARY_KEY>Yes</IDX_IS_PRIMARY_KEY><IDX_COLUMNS><IDX_COLUMN>as001_id</IDX_COLUMN>...
I would like to have
<IDXS>
<IDX name="as001_c01pk">
<IDX_IS_UNIQUE>Yes</IDX_IS_UNIQUE>
...
Enrico
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2013-09-19 08:52:36 | Re: xmlElement and \n |
Previous Message | Nathan Mailg | 2013-09-17 16:03:15 | Re: removing duplicates and using sort |