Re: Picture with Postgres and Delphi

BLOBs are PostgreSQL wierdness from before PostgreSQL had TOAST (which
removed the 8kb row limit). See

http://www.postgresql.org/docs/7.3/static/largeobjects.html

For info on the old BLOB interface.

Jon

On Thu, 11 Sep 2003, Network Administrator wrote:

> 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(at)eskimo(dot)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(at)yahoo(dot)com>:
> > >
> > > > --- Jonathan Bartlett <johnnyb(at)eskimo(dot)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
>