how to r/w blob field in php - Mailing list pgsql-sql

From danny
Subject how to r/w blob field in php
Date
Msg-id 200007270546.NAA22873@sh.fishinteractive.com
Whole thread Raw
List 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




pgsql-sql by date:

Previous
From: pgsql-sql@fc.emc.com.ph (pgsql-sql)
Date:
Subject: Re(2): optimize sql
Next
From: Thomas Swan
Date:
Subject: Classes, Inheritance, and Children