Marc Horvath, 14.03.2008 12:35:
I was wondering if anyone had any working sample code of inserting a
blob into a table and then retrieving one from a table for viewing?
I’m using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the
Java is 1.6.
I’m also running on a Windows XP Pro bo
I was wondering if anyone had any working sample code of inserting a blob
into a table and then retrieving one from a table for viewing?
I'm using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the Java
is 1.6.
I'm also running on a Windows XP Pro box if that matters.
Thanks,
Marc
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 23:16, Merlin Moncure wrote:
On 8/18/07, Ron Olson <[EMAIL PROTECTED]> wrote:
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL ha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 23:16, Merlin Moncure wrote:
> On 8/18/07, Ron Olson <[EMAIL PROTECTED]> wrote:
>> The language is Java. I've made some tests and they work very well for 25meg
>> filesworks exactly the way it should, first time. MySQL had all kinds of
On 8/18/07, Ron Olson <[EMAIL PROTECTED]> wrote:
> The language is Java. I've made some tests and they work very well for 25meg
> filesworks exactly the way it should, first time. MySQL had all kinds of
> nasty surprises for me when I first started working with blobs, but I can
> say that I too
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL had all kinds of
nasty surprises for me when I first started working with blobs, but I can
say that I took my code, changed the driver, and it all works like a ch
On 8/15/07, Ron Olson <[EMAIL PROTECTED]> wrote:
> Hi all-
>
> I am evaluating databases for use in a large project that will hold image
> data as blobs. I know, everybody says to just store pointers to files on the
> disk...can't do it here...the images are of a confidential nature and access
> to
On Wednesday 2007-08-15 05:52, Gregory Stark wrote:
> "Ron Olson" <[EMAIL PROTECTED]> writes:
> > Hi all-
> >
> > I am evaluating databases for use in a large project that will hold image
> > data as blobs. I know, everybody says to just store pointers to files on
> > the disk...
>
> Well not every
"Ron Olson" <[EMAIL PROTECTED]> writes:
> Hi all-
>
> I am evaluating databases for use in a large project that will hold image
> data as blobs. I know, everybody says to just store pointers to files on the
> disk...
Well not everyone. I usually do, but if you're not handling these blobs under
he
> So turning to Postgresql, can I get any recommendations, suggestions and
> tips on blob handling in the database? The image sizes will be pretty
> variable, from a few kilobytes to several hundred megabytes, so I need
> something that will handle the various file sizes, hopefully transparently.
>
Hi all-
I am evaluating databases for use in a large project that will hold image
data as blobs. I know, everybody says to just store pointers to files on the
disk...can't do it here...the images are of a confidential nature and access
to the database (and resulting client app) will be highly rest
On 04/07/2007 17:34, Cesar Alvarez wrote:
is there a way to store pictures or executables in postgres??
http://www.postgresql.org/docs/8.2/static/datatype-binary.html
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Irelan
On Jul 4, 2007, at 11:34 , Cesar Alvarez wrote:
is there a way to store pictures or executables in postgres??
From the PostgreSQL FAQ
4.10) What is the difference between the various character types?
http://www.postgresql.org/docs/faqs.FAQ.html#item4.10
From the PostgreSQL Documentation
8.4.
hello every one
is there a way to store pictures or executables in postgres??
Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Cesar Alvarez
title:Web Development Asesor and Software Enginner
version:2.1
end:vcard
---(end of broadcast)---
TIP 6: exp
Thanx for ur suggestion... But I face a new problem
now...
connection.setAutoCommit works well with postgresql
7.3 .. but with postgresql 7.4 I am getting the
error...
Error in connection == ERROR: SET AUTOCOMMIT TO OFF
is no longer supported
I have tried pg73jdbc1.jar and pg73jdbc3.jar .. both
[EMAIL PROTECTED] says...
> That's a good discussion, but it left out at least one useful bit of
> info about managing large objects: there's a contrib utility
> (contrib/vacuumlo) that can find and remove large objects that are not
> referenced anywhere in the database.
What is the URL for
On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee wrote:
> But unfortunately I could not extract this data to
> frontend thru java... I tried in two ways but got the
> same error...after getting the data in Blob or Large
> Object.
>
> Error in connection == FastPath call returned ERROR:
> inva
Thanks a lot for the clue... Now I am comfortably
handling the Lrge Objects thru SQL...
But unfortunately I could not extract this data to
frontend thru java... I tried in two ways but got the
same error...after getting the data in Blob or Large
Object.
Error in connection == FastPath call return
On 2 Oct 2003, Doug McNaught wrote:
> Howard Lowndes <[EMAIL PROTECTED]> writes:
>
> > OK, I'm convinced, except for one small, but not insignificant hiccup.
> > When you dump a database with the BLOBs, even with the -c option, and then
> > restore that database again with the -c option, you get
Howard Lowndes <[EMAIL PROTECTED]> writes:
> OK, I'm convinced, except for one small, but not insignificant hiccup.
> When you dump a database with the BLOBs, even with the -c option, and then
> restore that database again with the -c option, you get double the BLOBs.
> The original BLOBs are th
On Thu, 2 Oct 2003, Tom Lane wrote:
> Howard Lowndes <[EMAIL PROTECTED]> writes:
> > On Wed, 1 Oct 2003, Tom Lane wrote:
> >> No, because pg_restore has logic to adjust the references to match the
> >> new BLOB OIDs. If you have a test case where this fails to work, let's
> >> see it ...
>
> > N
Howard Lowndes <[EMAIL PROTECTED]> writes:
> On Wed, 1 Oct 2003, Tom Lane wrote:
>> No, because pg_restore has logic to adjust the references to match the
>> new BLOB OIDs. If you have a test case where this fails to work, let's
>> see it ...
> No, I don't have any example, it is an enquiry. Wha
On Wed, 1 Oct 2003, Tom Lane wrote:
> Howard Lowndes <[EMAIL PROTECTED]> writes:
> > Now, my concern is that if I use pg_dump with the --clean or --create, and
> > the --blobs options, and then try a pg_restore from the resulting archive
> > file, I believe the BLOBs will take up a different loi
Howard Lowndes <[EMAIL PROTECTED]> writes:
> Now, my concern is that if I use pg_dump with the --clean or --create, and
> the --blobs options, and then try a pg_restore from the resulting archive
> file, I believe the BLOBs will take up a different loid to the one they
> came from, and hence the
On Wed, 1 Oct 2003, Joshua D. Drake wrote:
> Hello,
>
> We usually have a table called something like file_objects that
> contains information like the loid, content-type, filesize etc...
> that we reference.
Yes, that's what I also have got:
test=> \d images
Table "images"
My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2
I have no difficulty inserting and managing BLOBs into the Large Object
system table, and I have a user table called images which maintains the
relationship between the BLOB loid and the identity that relates to it in
my user t
Any examples available, please?
On all of creating, insertion, updateing, setting it to null?
>From: Alex Pilosov <[EMAIL PROTECTED]>
>To: Richard Church <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: [GENERAL] Blobs in PostgreSQL
>Date: Wed, 27 Jun 2001
On Tue, Nov 14, 2000 at 10:35:52AM +0100, dominique papin wrote:
> But I kept an eye on the future development. Now I have read the summary
> of TOAST project which will be implemented in the future 7.1 release. It
> seems to me that it could fix my problem with blobs in postgresql, am i
> right
Hi,
In june, I had to migrate a web site using paradox tables on a winNT to
a Linux box. I had chosen first postgresql 7.0 for its solid-based
features.
But unfortunately, when I started to migrate my tables, a problem raised
: the implementation of blobs in Postgre. My tables stored lots of
blob
I recently ran into a big problems regarding blobs and rollback with postgreSQL 6.5.3
A table contains many entries and each entry includes a single
blob-oid. In a databaseprocessing perlscript I need to delete such a
blob and perform the lo_unlink and later I rollback the session without
commiti
Is there any way to enter a large object (Binary) into a database using
psql... or any other tool I can run from a shell script...
Ideally I need to be able to take stdin and put it in a particular place
in a table Then obviously get it back out later...
James ([EMAIL PROTECTED])
Vortex
31 matches
Mail list logo
