QUOTED_PRINTABLE_DECODE v11
Use the QUOTED_PRINTABLE_DECODE
function to translate an encoded quoted-printable string into a decoded RAW
string.
The signature is:
This function returns a RAW
value.
Parameters
r
r
contains the encoded string that will be decoded. The string is a RAW
value, encoded by QUOTED_PRINTABLE_ENCODE
.
Examples
Before executing the following example, invoke the command:
This command instructs the server to escape any non-printable characters, and to display BYTEA
or RAW
values onscreen in readable form. For more information, refer to the Postgres Core Documentation available at:
https://www.postgresql.org/docs/11/static/datatype-binary.html
The following example first encodes and then decodes a string: