HOw to convert unicode to string - Mailing list pgsql-sql

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