Functions / Binary String Functions And Operators

convert_to

Converts a text string (in the database encoding) to a binary string encoded in encoding dest_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_to ( string text, dest_encoding name ) → bytea

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

convert_to('some_text', 'UTF8') → \x736f6d655f74657874

Version history 4

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

Definition snapshot: b7bd9cda · English manual source