how to r/w blob field in php

From: danny <danny_ml1(at)sh(dot)fishinteractive(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: how to r/w blob field in php
Date: 2000-07-27 21:34:18
Message-ID: 200007270546.NAA22873@sh.fishinteractive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi, everyone

I decide to use text field to store large text but pgsql has 8k limit in insert statement.

I have read the sample of create large object of pg_sql in the php manual.
here it is:

Example 1. Using Large Objects

1
2 <?php
3 $database = pg_Connect ("", "", "", "", "jacarta");
4 pg_exec ($database, "begin");
5 $oid = pg_locreate ($database);
6 echo ("$oid\n");
7 $handle = pg_loopen ($database, $oid, "w");
8 echo ("$handle\n");
9 pg_lowrite ($handle, "gaga");
10 pg_loclose ($handle);
11 pg_exec ($database, "commit");
12 ?>
13

I am confused. According this sample, but which table and which record will be updated ?
Anyone has tried this ? Please give me a full sample

thanks

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-07-27 22:16:42 Re: Conditional rule?
Previous Message Robert B. Easter 2000-07-27 19:06:45 Re: Conditional rule?