Thread: How much the max image size can be inserted into Postgresql

Dear All,<br /><br /> I want to insert image which is more than 1 GB.is it possible to store that same size or we can
storemore than that.Please let me know .<br /><br />I am waiting for your great response.<br /><br />Advanced
Thanks,<br/><br />Regards<br />Venkat.<br /> 

venkat wrote:
> Dear All,
> 
>  I want to insert image which is more than 1 GB.is it possible to store
> that same size or we can store more than that.Please let me know .

Assuming that:

- You're using PostgreSQL 8.3, and
- You're using large objects to store your images; then

the appropriate section of the MANUAL is:
http://www.postgresql.org/docs/current/static/largeobjects.html

If those assumptions are invalid or insufficient, perhaps you could
provide a more complete description of how you're doing things?

--
Craig Ringer

On Wed, Dec 24, 2008 at 7:00 AM, venkat <ven.tammineni@gmail.com> wrote:
> Dear All,
>
>  I want to insert image which is more than 1 GB.is it possible to store that
> same size or we can store more than that.Please let me know .

Wow.  The need for transactional semantics and storage of > 1Gig file
size is an odd set of requirements.