pg_unescape_bytea
PHP function
Edit on GitHub ✎
(PHP 4 >= 4.3.0, PHP 5, PHP 7, PHP 8)
Unescape binary for bytea type
Description
pg_unescape_bytea(string $string): string
pg_unescape_bytea() unescapes PostgreSQL bytea data values. It returns the unescaped string, possibly containing binary data.
Note
When you SELECT a bytea type, PostgreSQL returns octal byte values prefixed with '\' (e.g. \032). Users are supposed to convert back to binary format manually.
Parameters
stringA
stringcontaining PostgreSQL bytea data to be converted into a PHP binary string.
Return Values
A string containing the unescaped data.
Examples
pg_unescape_bytea() example
php
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Get the bytea data
$res = pg_query("SELECT data FROM gallery WHERE name='Pine trees'");
$raw = pg_fetch_result($res, 'data');
// Convert to binary and send to the browser
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
?>