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)