Re: Display large object from database - Mailing list pgsql-novice

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@postgresql.org
Sent:  Mon, 05 Jun 2006 10:55:26 -0400
Subject: Re: [NOVICE] Display large object from database

"Greg" <greg@officium.co.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