If it was me, I'd use serial unique to arbitrarily assign IDs to blobs.
Cima wrote:
> hi,
> i sent a mail asking about downloading files. the files i stored in my
> database are stored as blobs, just in case.
>
> now i had also asked on another ocasion, if the oids arent as reliable
> as i had thought, then what should i use as an alternative to the oids
> for my files? bear i mind that i would like to store my files as blobs.
> also, how efficient is it to try and store files as blobs and is it
> recommended?