"Rick Gigger" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
