PostgreSQL/Postgre SQL/Decode

Decode binary string from string previously encoded with encode

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=#