Re: Picture with Postgres and Delphi

I thought "bytea" was PG's version of BLOBs.  I don't see a "blob" type in the
current docs.

Also, I saw your example code as well.  I use Perl as well but I use the native
Pg.pm module.  There doesn't seem to be a way to switch the input to binary data
but there is support for what is called "large object" which is I think what I
might want.  If you or anyone else out there has worked with bytea's with
module, I appreciate some direction and any other wisdom (e.g. pros/cons,
catch22's, etc).  Thanks!

Learning everyday...



Quoting Jonathan Bartlett <johnnyb@eskimo.com>:

> > I'll try that out.  I'll have to research that base64 encoding part because
> I'll
> > only every do text dumps.
>
> Oh yea, I forgot, bytea columns come out just fine in text dumps (BLOBs
> don't, however).
>
> Jon
> >
> > Keith-
> >
> > Quoting Jeff Eckermann <jeff_eckermann@yahoo.com>:
> >
> > > --- Jonathan Bartlett <johnnyb@eskimo.com> wrote:
> > > > I'm a big fan of bytea.  In every case where I've
> > > > done the filesystem
> > > > method I wished I hadn't.
> > >
> > > For the education of me and maybe others too, why was
> > > that?  i.e. what problems did you run into, that bytea avoids?
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > > http://sitebuilder.yahoo.com
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 8: explain analyze is your friend
> > >
> >
> > --
> > Keith C. Perry
> > Director of Networks & Applications
> > VCSN, Inc.
> > http://vcsn.com
> >
> > ____________________________________
> > This email account is being host by:
> > VCSN, Inc : http://vcsn.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faqs/FAQ.html
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com