Re: postgres blobs and PHP

Поиск
Список
Период
Сортировка
От Adam Haberlach
Тема Re: postgres blobs and PHP
Дата
Msg-id 20001201193051.A14464@ricochet.net
обсуждение исходный текст
Ответ на postgres blobs and PHP  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Ответы Re: postgres blobs and PHP  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Список 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 по дате отправления:

Предыдущее
От: Mike Castle
Дата:
Сообщение: Re: OVERLAPS
Следующее
От: 100.179370@germanynet.de (Martin Jacobs)
Дата:
Сообщение: postmaster of 7.0.3 listening but pslq cannot connect