From: omkar prabhu <omprab@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: help transfer ring blobs using perl
Date: Fri, 28 Nov 2003 03:19:44 -0800 (PST)
Message-ID: <20031128111944.79948.qmail@web40209.mail.yahoo.com> (raw)
i am using postgres 7.0.3
and also postgres 7.2.1
I am new towards using blobs,I want to transfers
records with blobs from a table to different
database(postgres) using
perl without extracting the blob to disk(i.e without
using lo_export/lo_import).
Below is my perl script which is not working can
anybody help in this.
$rest = $conn->exec("begin");
$stmt="select * from image ;";
$result = $conn->exec($stmt);
if ( $result->resultStatus ne PGRES_TUPLES_OK )
{
die $conn->errorMessage unless PGRES_TUPLES_OK eq
$result->resultStatus;
}
$n=$result->ntuples;
print "\n Number of Processes Scheduled $n \n";
while ( @row=$result->fetchrow)
{
$fld=$row[0];
$fd=Pg::lo_open($conn,$fld,"r");
if ( $fd )
{
$buf="";
Pg::lo_read($conn,$fd,$buf,20000);
}
Pg::lo_close($conn,$fd);
$foid=Pg::lo_creat($conn,"w");
$fdw=Pg::lo_open($conn,$foid,"w");
Pg::lo_write($conn,$fdw,$buf,20000);
Pg::lo_close($conn,$foid);
$stmt="insert into photo values($foid)";
$resi = $conn->exec($stmt);
if ( $resi->resultStatus ne PGRES_COMMAND_OK )
{
die $conn->errorMessage unless PGRES_TUPLES_OK eq
$resi->resultStatus;
}
}
$rest = $conn->exec("end");
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: omprab@yahoo.com
Subject: Re: help transfer ring blobs using perl
In-Reply-To: <20031128111944.79948.qmail@web40209.mail.yahoo.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