DECODE
The DECODE function is a PostgreSQL function used for decoding or extracting binary data from a textual input string.
Syntax
The following shows the correct syntax for the DECODE function:
decode(string input_text, format type_text)
Parameters
The following table shows the DECODE parameters:
Parameter |
Description |
---|---|
|
Defines the input text string. |
|
Defines the format used for decoding the input text. |
Returns
Comment - What does it return?
Notes
Comment - Are there any relevant notes?
Examples
Comment - What does the actual output look like? Can you provide an example?
Permissions
Comment - Please confirm what permissions the role requires.
The role must have the SUPERUSER
permissions.