PostgreSQL/Postgre SQL/Decode

Decode binary string from string previously encoded with encode

   <source lang="sql">

postgres=# -- decode(string text, type text) postgres=# -- Decode binary string from string previously encoded with encode. postgres=# -- Parameter type is same as in encode. postgres=# select decode("123\\000456", "escape") postgres-# postgres-# ;

  decode

---

123\000456

(1 row) postgres=#

      </source>