"Rick Gigger" <rick@alpinenetworking.com> writes:
> What is the best method for storing files in postgres? Is it better to use
> the large object functions or to just encode the data and store it in a
> regular text or data field?
Depends on whether you need "random access" to the contents. You can
lo_seek() inside a large object and retrieve parts of the data with
lo_read(), while 'text' and 'bytea' currently require fetching the
whole field.
-Doug