Re: Picture with Postgres and Delphi - Mailing list pgsql-general

Ahh ok, thats in the programmers docs.  Ok, so I'm guessing that really large
object support (BLOBs) are depreciated in favor of using the "bytea" or "text"
types, yes?  I would this this to be true since your "object" is contain within
a single record and non spanned because of row limit (i.e. before TOAST).

So then the "large object" function in the Pg.pm are not what I'm looking for.
I'm back to square one- How does one actually insert a file into a table using
Pg.pm or more importantly psql?  I'm more concerned about doing this on the
system first since that is where I would be scripting the initial load of all
the images- something like that should not be done via a web client.

Quoting Jonathan Bartlett <johnnyb@eskimo.com>:

> 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@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
> >
>


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

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