Large objects

Started by Luis Martinsalmost 26 years ago2 messagesgeneral
Jump to latest
#1Luis Martins
kalium@usa.net

Hi everyone, I have to insert a few PDF files into my database, and I
am not able to do it ...
I have to use PHP3, and all I could do was use the lo_import, but in
this case, I am not able to insert any data because I am not an
administrator. Is there any other way of doing it, using, let's say,
pg_locreate, pg_loopen, or something like that ?
Thanx in advance.

Luis

--
__________________________
Luis Martins
Eng. Sistemas e Computacao
UCEH - Univ. do Algarve
__________________________
email : kalium@usa.net
__________________________

#2Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Luis Martins (#1)
Re: Large objects

Hi everyone, I have to insert a few PDF files into my database, and I
am not able to do it ...
I have to use PHP3, and all I could do was use the lo_import, but in
this case, I am not able to insert any data because I am not an
administrator. Is there any other way of doing it, using, let's say,
pg_locreate, pg_loopen, or something like that ?
Thanx in advance.

Of course you can. The essential part of the program should look like:

pg_exec($con,"begin");
$oid = pg_locreate($con);
$lobj = pg_loopen($con,$oid,"w");
/* read your PDF file contents into $img variable */
pg_lowrite($lobj,$img);
pg_loclose($lobj);
pg_exec($con,"end");
--
Tatsuo Ishii