↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

convert_from

Converts a binary string representing text in encoding src_encoding to text in the database encoding (see Section 23.3.4 for available conversions).

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

Converts a binary string representing text in encoding src_encoding to text in the database encoding (see Section 23.3.4 for available conversions).

Signatures and overloads

convert_from ( bytes bytea, src_encoding name ) → text → text
Converts a binary string representing text in encoding src_encoding to text in the database encoding (see Section 23.3.4 for available conversions).

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:5b96fa169db302f77a0c433abc9eedab8fc04a75ce0f203b5ae89837dd9b05e3

Text language: en · wiki-repair-20261023:5b96fa169db302f77a0c433abc9eedab8fc04a75ce0f203b5ae89837dd9b05e3