467,149 Members | 1,337 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

help transfer ring blobs using perl

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
print "\n Number of Processes Scheduled $n \n";

while ( @row=$result->fetchrow)
if ( $fd )

$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


$rest = $conn->exec("end");

Do you Yahoo!?
Free Pop-Up Blocker - Get it now

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #1
  • viewed: 1031

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by FLOTServer | last post: by
1 post views Thread by picaza | last post: by
7 posts views Thread by Howard Lowndes | last post: by
27 posts views Thread by SK | last post: by
17 posts views Thread by Yuri CHUANG | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.