[RESOLVED] Storing files in pgsql (bytea) via php?

jara06

I've been fooling a bit around with the 'bytea' datatype in Postgres for some hours now, but I cant really make it work...
I tried the exact same code on my homepc (WinXP, php 5.0.4 & pgsql 8.1.14) and here all goes well, but in my test enviroment (described below) the row is being inserted but with the bytea field empty..

Im running this from a webserver on FC linux (apache 2.0.54, php 5.0.4), and using a pgsql server on another FC linux (pgsql 8.1.4).
I created a table w those fields: name => text, pic => bytea, no constraints, nothing.
Loaded a file manually in php and ran this:

// test for bytea
	$dbconn = pg_connect('host=dev02 port=5432 dbname=testing user=tester');
	$data = file_get_contents('./test.jpg');
	$escaped = pg_escape_bytea($data);
	//$escaped = 'testing..';	// this will work though
	pg_query('INSERT INTO public."TESTByteA" ("name", "pic") VALUES (\'asd\', \''. $escaped .'\');');
	die('done, row should exist now?');

I've not set up this test env so I dont know if special configs are used, but I can get them if nessecary..
So, out of curiosity, can this somehow be disabled or are there something else I've missed? 😕

SumitGupta

Hi,

You can compare php.ini on both environment, if they have some difference. Also, they way Windows handle to image can be different to linux in few ways that might cause the problem. though your Postgres doesn't seems to have problem , if you are able to get it inserted.

try print the insert query in both system, and compare. If they are same, run query directly on postgres without using PHP, and use Postgres command line and see the effect.

Hope that help in debugging. I cannot help much as don't know postgres myself