From: danny <danny_ml1@sh.fishinteractive.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: how to r/w blob field in php
Date: Thu, 27 Jul 2000 13:34:18 -0800
Message-ID: <200007270546.NAA22873@sh.fishinteractive.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: danny_ml1@sh.fishinteractive.com
Subject: Re: how to r/w blob field in php
In-Reply-To: <200007270546.NAA22873@sh.fishinteractive.com>
References: <200007270546.NAA22873@sh.fishinteractive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox