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.