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 <[EMAIL PROTECTED]>: > > 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 <[EMAIL PROTECTED]>: > > > > > --- Jonathan Bartlett <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
