pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





Message-ID: <200007270546.NAA22873@sh.fishinteractive.com>
Permalink:  ../200007270546.NAA22873@sh.fishinteractive.com/
Also on:    postgresql.org/message-id/200007270546.NAA22873@sh.fishinteractive.com

 · 

reply

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