Problem with Large Objects

Поиск
Список
Период
Сортировка
От Dorin Grunberg
Тема Problem with Large Objects
Дата
Msg-id 4.2.0.58.19991112141528.00a56e60@pophost
обсуждение исходный текст
Список pgsql-interfaces
I am trying to recreate the example from the Postgresql manual using Perl 
and DBI.

I was able to insert the image 'inside' the table. I checked the /tmp 
directory to see if it is there.

When I run the following lines I get the output an "1"


my $sth = $dbh->prepare_cached(qq{SELECT lo_export(image.file, 
'/tmp/Patti.jpg') from image WHERE name='picture'}) || die "Can't prepare 
statement: $DBI::errstr";

my $rc = $sth->execute || die "Can't execute statement: 
$DBI::errstr";
                while (($picture) = $sth->fetchrow_array() ) {                    print $picture;
                }

What am I doing wrong here?




В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [INTERFACES] my problems with ecpg and arrays
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: [INTERFACES] RE: THE Postgres WEB SITE