Re: postgres blobs and PHP - Mailing list pgsql-general

From Adam Haberlach
Subject Re: postgres blobs and PHP
Date
Msg-id 20001201193051.A14464@ricochet.net
Whole thread Raw
In response to postgres blobs and PHP  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Responses Re: postgres blobs and PHP
List pgsql-general
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@newsnipple.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

pgsql-general by date:

Previous
From: Mike Castle
Date:
Subject: Re: OVERLAPS
Next
From: 100.179370@germanynet.de (Martin Jacobs)
Date:
Subject: postmaster of 7.0.3 listening but pslq cannot connect