xmlElement and \n

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

Responses

Browse pgsql-sql by date

  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