Functions / Binary String Functions And Operators

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).

Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

convert_from ( bytes bytea, src_encoding name ) → 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).

convert_from('text_in_utf8', 'UTF8') → text_in_utf8

Version history 4

16 → 17 changed
13 → 14 changed
12 → 13 changed
8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source