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
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? |