From: | Jeff MacDonald <jeff(at)hub(dot)org> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | |
Date: | 1999-09-16 14:34:50 |
Message-ID: | Pine.LNX.4.10.9909161129070.27527-100000@penguin.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Got a presumably very quick question.
I'm writing a perl script. lets say i have a variable that's > 8k
, for arguments sake it's 64k.
How can i insert this into a database, do i need large objects ?
and if so, do i use the lo_import ? for some reason it seems that
this is only for files..
below is what i have but it doesn't seem to work..
jeff=> \d test
Table = test
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| blurb | text | var |
| message | oid | 4 |
+----------------------------------+----------------------------------+-------+
***************** code ********************
#!/usr/bin/perl
use strict;
use DBI;
my $dbh = DBI->connect("dbname=narf host=narf port=narf",'narf','','Pg',{'AutoCommit' => 0});
if (!$dbh) {
exit print "Could not connect: $DBI::errstr\n";
}
## lets create the large value here...
## this string is 64K (2^16)
my $largestring = 'x';
for (my $i=0;$i < 16 ;$i++) {
$largestring = $largestring . $largestring;
}
my $statement = $dbh->prepare("INSERT INTO test values('something',lo_import($largestring));");
$statement->execute();
$statement->finish();
$dbh->commit;
$dbh->disconnect;
thanks for the help.
======================================================
Jeff MacDonald
jeff(at)hub(dot)org webpage: http://hub.org/~jeff
jeff(at)pgsql(dot)com irc: bignose on EFnet
======================================================
From | Date | Subject | |
---|---|---|---|
Next Message | xiaopeng.zhang | 1999-09-16 16:34:41 | Help, install 6.5 on Linux2.0.35 |
Previous Message | José Soares | 1999-09-16 12:49:49 | Re: [SQL] CREATE FUNCTION |