Re: bytea and text

On Friday 27 November 2009 02:58:01 Tom Lane wrote:
> "Jean-Yves F. Barbier" <12ukwn(at)gmail(dot)com> writes:
> > I'm asking myself what solution for storing pictures is the best:
> >
> > * using a BYTEA column type, and having no intrinsic compression gain
> > because a picture it almost every time already compressed,
> >
> > * using a TEXT column type, and store a Base64(picture) in it; it should
> > take benefits of intrinsic compression (?).
>
> At best, the compression would get rid of the overhead you added by
> converting to base64. It probably wouldn't completely succeed at that,
> though, meaning the second alternative is always a loser.
>
> regards, tom lane
>

tom, I wonder if you could give us a sample of using client side lo_creat ,
insert functions to insert a blob into postgres - in an sql statement.

Despite reading the docs's I'm totally in the dark and can't understand the
syntax.

Regards

richard (using gambas basic)