Ok, reading the PostgreSQL documentation on blobs helped :) From what I can tell, there is no way to write a blob directly; from a scalar; instead you have to use the lo_import and lo_export methods with disk-based files, the way you are doing it now. As much as MySQL gets picked on for not being a "real" RDBMS, it seems a lot better suited for what you want to do here than PostgreSQL.
|Replies are listed 'Best First'.|
RE: Re: Difficulty inserting a large object using DBD::Pg (kudra: I was right, which isn't good for a change)
by kudra (Vicar) on Jun 29, 2000 at 20:48 UTC