Re: postgres blobs and PHP

On Fri, Dec 01, 2000 at 07:30:19PM -0300, Martin A. Marques wrote:
> I know I bothered with this, but I just don't get it.
> Lets say I have a test table like this in a certain database:
>
> CREATE TABLE test (
> id_test SERIAL,
> blob_text oid
> );
>
> Now I want to insert a good chunk of text in the blob_text field with PHP.
> PHP has some postgres functions like pg_locreate, pg_lowrite, pg_loread, etc,
> but it never specifies the table and it doesn't specify the field in the
> table.
> Now how does php know where to write the chunk of text (or the image, or
> whatever)?
> Can someone give me a hand?

It sticks it somewhere. It is up to you to keep track of the Oid that
lo_create gives you and stash it in your table so you can lo_open it later.

--
Adam Haberlach |"California's the big burrito, Texas is the big
adam(at)newsnipple(dot)com | taco ... and following that theme, Florida is
http://www.newsnipple.com| the big tamale ... and the only tamale that
'88 EX500 | counts any more." -- Dan Rather