[SQL] HOw to convert unicode to string

[Abhijit Prusty -X (abprusty - UST Global at Cisco)]

Hi,

I have a query in oracle like this mentioned below

Insert into TEST
   (TEMPLATE_ID, TEMPLATE_NAME, CREATED_BY, CREATED_DT, UPDATED_BY,
    UPDATED_DT, TEMPLATE_KEY)
Values
   (1, UNISTR('\D3C9\BA85\B3C4 \B514\C2A4\D50C\B808\C774'), 'dmin', SYSDATE, 
'admin',
    SYSDATE ,'FLOOR');

Now the oracle uses the UNISTR function to convert and insert the Unicode to 
string and store in database.

But, how can we achieve the same using the PostgreSql .Can you please help me 
with the query


Thanks,
Abhijit