pg_escape_bytea

Nota: When you SELECT bytea type, PostgreSQL returns octal byte value prefixed by \ (e_g_ \032)_ Users are supposed to convert back to binary format by yourself_

This function requires PostgreSQL 7_2 or later_ With PostgreSQL 7_2_0 and 7_2_1, bytea type must be casted when you enable multi_byte support_ i_e_ INSERT INTO test_table (image) VALUES ('$image_escaped'::bytea); PostgreSQL 7_2_2 or later does not need cast_ Exception is when client and backend character encoding does not match, there may be multi_byte stream error_ User must cast to bytea to avoid this error_