xml to string, ascii x utf8 conversion - Mailing list pgsql-general

From Radek Novotný
Subject xml to string, ascii x utf8 conversion
Date
Msg-id 200907201846.01359.radek.novotny@mediawork.cz
Whole thread Raw
Responses Re: xml to string, ascii x utf8 conversion
List pgsql-general
Hello,
having problem with conversion while doing function query_to_xml.


query_to_xml('select Nazev as "TITLE", Datum as "DATE", Autor_Akce as "meta rel=''action_author''", ....


gave me


<table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
<TITLE>Test</TITLE>
<DATE>2009-07-20</DATE>
<meta_x0020_rel_x003D__x0027_action_author_x0027_>test </meta_x0020_rel_x003D__x0027_action_author_x0027_>


How can i transcode this well generated xml(ascii) to string(UTF8) without the escape characters?


I found nothing on google...


Regards,
Radek Novotny



--

www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online streaming) a videoarchív ve formátu FLASH.


Bc. Radek Novotný
jednatel Mediawork group s.r.o.


tel.: +420 724 020 361
email: radek.novotny@mediawork.cz
http://www.mediawork.cz

pgsql-general by date:

Previous
From: Dan Armbrust
Date:
Subject: Re: Checkpoint Tuning Question
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: suggestion: log_statement = sample