Re: postgres blobs and PHP
| From: | Richard Lynch | Date: | Mon, 04 Dec 2000 05:09:45 +0000 |
| Subject: | Re: postgres blobs and PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28523@lists.php.net to get a copy of this message | ||
When you create a LO, you get a unique OID, and stuff that into your table.
It's basically an iNode sort of thingie -- you get a unique number that
points to your blob, and you keep track of it.
----- Original Message -----
From: "Martin A. Marques" <martin@math.unl.edu.ar>
Newsgroups: php.general
Sent: Friday, December 01, 2000 4:39 PM
Subject: [PHP] postgres blobs and PHP
> 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?
>
> TIA.
>
>
> --
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -----------------------------------------------------------------
> Martín Marqués email: martin@math.unl.edu.ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>