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

input_text

Defines the input text string.

type_text

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.