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

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

See if you have a function like pg_escape_bytea and pg_unescape_bytea.
If you do, you can escape the data, and then just stick it in quotes in
your query.

As far as selecting the data, I don't think Perl needs to unescape it, but
I could be wrong.

Jon


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