Re: Display large object from database

Thanks, I read the pgAdmin help on a bytea column, but it doesn't specify its maximum size. What is
the largest filesize I can fit into a bytea column?

Thanks

----- Original Message -----
From: Tom Lane
To:
Cc: pgsql-novice(at)postgresql(dot)org
Sent: Mon, 05 Jun 2006 10:55:26 -0400
Subject: Re: [NOVICE] Display large object from database

"Greg" <greg(at)officium(dot)co(dot)za> writes:
> I am battling to open the image for reading into a stream.

From what? The lo_xxx functions are intended to be used from C, not
from SQL.

You might be better off using a bytea column, which is a far simpler
construct than a large object. It won't give you streamwise access,
just fetch or store the whole value at once, but that might be all you
need.

regards, tom lane