Re: Picture with Postgres and Delphi

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: Network Administrator <netadmin(at)vcsn(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Picture with Postgres and Delphi
Date: 2003-09-11 17:49:21
Message-ID: Pine.GSU.4.44.0309111048140.27482-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)eskimo(dot)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(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
> > >
> >
>
>
> --
> Keith C. Perry
> Director of Networks & Applications
> VCSN, Inc.
> http://vcsn.com
>
> ____________________________________
> This email account is being host by:
> VCSN, Inc : http://vcsn.com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-09-11 18:13:19 Re: Picture with Postgres and Delphi
Previous Message Keith G. Murphy 2003-09-11 17:49:09 Re: The ..... worm