pg_escape_bytea

Escape a string for insertion into a bytea field

string **pg_escape_bytea** PgSql\Connection $connection string $data

escapes string for

bytea datatype. It returns escaped string. pg_escape_bytea

Opmerking: > When you a bytea type, PostgreSQL returns octal byte values prefixed with '' (e.g. \032). Users are supposed to convert back to binary format manually. SELECT
This function requires PostgreSQL 7.2 or later. With PostgreSQL
7.2.0 and 7.2.1, bytea values must be cast when you enable
multi-byte support. i.e.  PostgreSQL 7.2.2 or
later does not need a cast. The exception is when the client and backend
character encoding does not match, and there may be multi-byte
stream error. User must then cast to bytea to avoid this error.
INSERT INTO test_table (image) VALUES ('$image_escaped'::bytea);

connection``data A containing text or binary data to be inserted into a bytea column. string

A containing the escaped data. string

Voorbeeld: example

<?php 
  // Connect to the database
  $dbconn = pg_connect('dbname=foo');
  
  // Read in a binary file
  $data = file_get_contents('image1.jpg');
  
  // Escape the binary data
  $escaped = pg_escape_bytea($data);
  
  // Insert it into the database
  pg_query("INSERT INTO gallery (name, data) VALUES ('Pine trees', '{$escaped}')");
?>

pg_unescape_bytea``pg_escape_string

Vorige ← pg_end_copy Volgende pg_escape_identifier →

pg_escape_bytea

pg_escape_bytea

Documentatie