On 2012-01-03, Maurício Cruz wrote:
> Hi all,
>
> I'm trying to use lo_import to import a file into my database, if I
> execute from postgres runing in my local machine
> it works perfectly, but if I do it in the postgres runing in the server,
> it says "No such file or directory"
>
> I Guess po
Maurício Cruz wrote:
> I'm trying to use lo_import to import a file into my
> database, if I execute from postgres runing in my local
> machine
> it works perfectly, but if I do it in the postgres runing in
> the server, it says "No such file or directory"
> I Guess postgres only see file on the
Hi all,
I'm trying to use lo_import to import a file into my database, if I
execute from postgres runing in my local machine
it works perfectly, but if I do it in the postgres runing in the server,
it says "No such file or directory"
I Guess postgres only see file on the machine it is runing
You can use 'DBI'
from test.pl of DBD::Pg
# create large object from binary file
my ($ascii, $pgin);
foreach $ascii (0..255) {
$pgin .= chr($ascii);
};
my $PGIN = '/tmp/pgin';
open(PGIN, ">$PGIN") or die "can not open $PGIN";
print PGIN $pgin;
close PGIN;
# begin transaction
$dbh->{AutoCo
I need to store a binary file in a database. I use a cgi writed in shell
to do it. So I can use Postgres user to execute the cgi.
How can I store a binary file in a database with a cgi ?
Thanks a lot.
Laurent.
---(end of broadcast)---
TIP 2: y
Hi,
I am trying to develop a client application in Visual Basic that will run on
MS Windows98 and will communicate via ODBC with a Postgres server on
Solaris. I need to store Blob's from the client drive (images) to the
Postgres DB. I tried to use lo_import/lo_export but apparently they only
work
