http://qs321.pair.com?node_id=522370


in reply to Re: postgresql bytea escaping
in thread postgresql bytea escaping

Don't the lo family functions create OID in your pg database, which are references to the file system? I chose bytea, because I know the binary data will typically be less the 10 mb, and I didn't want to have the extra mangement headache of keeping the external file system synced. If I am wrong in understanding the way the lo functions work, please correct me.

Replies are listed 'Best First'.
Re^3: postgresql bytea escaping
by ioannis (Abbot) on Jan 15, 2006 at 01:50 UTC
    The created OID is a reference to pg_largeobject.loid, the table where the binary data are stored. The data are already copied into the database.