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
On Thu, Sep 19, 2013 at 9:46 AM, Enrico Oliva wrote:
> I would like to have
>
>
> Yes
> ...
I'm not sure there is an indenting facility, since indentation
strongly depends on what the user think about.
However you can concatenate a new line at each xmlelement call:
SELECT xmleleme
