postgres blobs and PHP

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres blobs and PHP
Date: 2000-12-01 22:30:19
Message-ID: 00120119301900.22399@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alain Toussaint 2000-12-01 23:14:43 Re: Database cluster?
Previous Message Martin Jacobs 2000-12-01 22:13:44 Re: strange error (32 512)