Decode binary string from string previously encoded with encode : Decode « Postgre SQL « PostgreSQL

1. PostgreSQL
2. Postgre SQL
3. 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=#

           
       

Related examples in the same category