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 <[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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
