(PHP 4 >= 4.3.0, PHP 5)
pg_unescape_bytea — bytea ｷｿ､ﾎ･ﾐ･､･ﾊ･熙｢･ｨ･ｹ･ｱ｡ｼ･ﾗ､ｹ､�
pg_unescape_bytea() ､ﾏ｡｢bytea ｷｿ､ﾎ･ﾇ｡ｼ･ｿﾊｸｻ昀� ･｢･ｨ･ｹ･ｱ｡ｼ･ﾗ､ｷ｡｢･ｨ･ｹ･ｱ｡ｼ･ﾗ､ｷ､ﾆ､､､ﾊ､､ﾊｸｻ昀�(･ﾐ･､･ﾊ･�)､ﾖ､ｷ､ﾞ､ｹ｡｣
ﾃ擎ﾕ:
bytea ｷｿ､� SELECT ､ｷ､ｿｾ�遑｢PostgreSQL ､ﾏ '\' ､ﾇ ｻﾏ､ﾞ､� 8 ｿﾊｿﾎ･ﾐ･､･ﾈﾃﾍ｡ﾊﾎ�: \032｡ﾋ､ﾖ､ｷ､ﾞ､ｹ｡｣､ｳ､�譯ｼ･ｶ､ｬｼ�ｰ､ﾇ ･ｳ･ﾐ｡ｼ･ﾈ､ｹ､�ｳ､ﾈ､�ﾔ､ｵ､�ﾆ､､､ﾞ､ｹ｡｣
､ｳ､ﾎｴﾘｿﾏ PostgreSQL 7.2 ｰﾊｹﾟ､ﾎ･ﾐ｡ｼ･ｸ･逾ｬﾍﾗ､ﾈ､ｷ､ﾞ､ｹ｡｣PostgreSQL 7.2.0 ､ｪ､隍ﾓ 7.2.1 ､ﾇ､ﾏ｡｢･ﾞ･�ﾁ･ﾐ･､･ﾈ､ﾎ･ｵ･ﾝ｡ｼ･ﾈ､ｭｸ妤ﾋ､ｷ､ｿｾ�遉ﾏ bytea ､ﾎﾃﾍ､ｭ･罕ｹ･ﾈ､ｹ､�ｬﾍﾗ､ｬ､｢､熙ﾞ､ｹ｡｣ﾎ�: INSERT INTO test_table (image) VALUES ('$image_escaped'::bytea); PostgreSQL 7.2.2 ｰﾊｹﾟ､ﾇ､ﾏ･ｭ･罕ｹ･ﾈ､ｹ､�ｬﾍﾗ､ﾏ､｢､熙ﾞ､ｻ､｣ ･ｯ･鬣､･｢･ﾈ､ﾈ･ﾐ･ﾃ･ｯ･ｨ･ﾉ､ﾎﾊｸｻ妺ｨ･ｳ｡ｼ･ﾇ･｣･ｰ､ｬｰ�ﾗ､ｷ､ﾊ､､ｾ�遉ﾏ ﾎ羌ｰ､ﾇ｡｢､ｳ､ﾎｾ�遉ﾏ･ﾞ･�ﾁ･ﾐ･､･ﾈ･ｹ･ﾈ･遙ｼ･爭ｨ･鬘ｼ､ｬﾈｯﾀｸ､ｷ､ﾞ､ｹ｡｣､ｳ､ﾎ ･ｨ･鬘ｼ､ｱ､�ｿ､皃ﾋ､ﾏ bytea ｷｿ､ﾘ､ﾎ･ｭ･罕ｹ･ﾈ､ｬﾉｬﾍﾗ､ﾋ､ﾊ､熙ﾞ､ｹ｡｣
PHP ､ﾎ･ﾐ･､･ﾊ･�ｸｻ昀ﾋﾊﾑｴｹ､ｹ､� PostgreSQL ､ﾎ bytea ･ﾇ｡ｼ･ｿ､ﾞ､� ﾊｸｻ昀｣
･｢･ｨ･ｹ･ｱ｡ｼ･ﾗ､ｵ､�ｿ･ﾇ｡ｼ･ｿ､ｸｻ昀ﾇﾊﾖ､ｷ､ﾞ､ｹ｡｣
ﾎ�1 pg_unescape_bytea() ､ﾎﾎ�
<?php
// ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋﾀﾜﾂｳ､ｹ､�
$dbconn = pg_connect('dbname=foo');
// bytea ･ﾇ｡ｼ･ｿ､霹ﾀ､ｹ､�
$res = pg_query("SELECT data FROM gallery WHERE name='Pine trees'");
$raw = pg_fetch_result($res, 'data');
// ･ﾐ･､･ﾊ･熙ﾋﾊﾑｴｹ､ｷ｡｢･ﾖ･鬣ｦ･ｶ､ﾋﾁｮ､ｹ､�
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
?>