↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

decode

Decodes binary data from a textual representation; supported format values are the same as for encode.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
binarystring
group label
Binary String Functions And Operators
lang
en
layout
table-new
pages
functions-binarystring.html
prose only
false

Definition PG 18

Decodes binary data from a textual representation; supported format values are the same as for encode.

Signatures and overloads

decode ( string text, format text ) → bytea → bytea
Decodes binary data from a textual representation; supported format values are the same as for encode.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:6114afe21f65cab35572869b228346f948b64b256df1d012d4080ede9b0fbd3f

Text language: en · wiki-repair-20261023:6114afe21f65cab35572869b228346f948b64b256df1d012d4080ede9b0fbd3f