I have string 'test\data' or just one backslash symbol '\'.
How it convert to bytea?
Asked
Active
Viewed 2,896 times
7
marvinorez
- 593
- 4
- 7
-
4Use the `convert_to` function: http://www.postgresql.org/docs/current/static/functions-binarystring.html – Dec 21 '13 at 10:30
-
1Thanks!) `select convert_to('test\data'::text, 'utf8')` – marvinorez Dec 21 '13 at 10:42
1 Answers
2
Backlashes need special handling if casted from to bytea see src/backend/utils/adt/varlena.c.
Thus escape each backslash using replace('test\data', '\', '\\')::bytea before casting to bytea.
You could also use the already suggested function convert_to(text, encoding) bytea. But note that this function is not IMMUTABLE and thus it can't be used in any context out of the box.
FireEmerald
- 1,002
- 12
- 21