Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^2: postgresql bytea escaping

by ketema (Scribe)
on Jan 11, 2006 at 02:10 UTC ( #522370=note: print w/replies, xml ) Need Help??

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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://522370]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (6)
As of 2022-12-07 13:13 GMT
Find Nodes?
    Voting Booth?

    No recent polls found