Re: Insert ImageFile in PostgreSQL - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Insert ImageFile in PostgreSQL
Date
Msg-id 1123226587.15416.90.camel@sabrina.peacock.de
Whole thread Raw
In response to Re: Insert ImageFile in PostgreSQL  ("silasju@gmail.com" <silasju@gmail.com>)
List pgsql-general
Am Dienstag, den 02.08.2005, 08:52 -0700 schrieb silasju@gmail.com:
> I'm sorry, but I know only the basics about DBMs, but I think is not
> possible to put a image file INSIDE a database. You can put in a
> database the path of the file...
>
> (Maybe I'm wrong...)

sorry to say that, but indeed you are ;)
Postgres has 2 ways to accomplish this:

one is to use large objects (lo) which is
a bit painfull with the interface and w/
backups.

the other is just to store the file data
in a bytea field, which is limited in
size (1GB) and requires you to fetch the
complete file data at once.

--
Tino Wildenhain <tino@wildenhain.de>


pgsql-general by date:

Previous
From: Gregory Youngblood
Date:
Subject: Re: DNS vs /etc/hosts
Next
From: Tino Wildenhain
Date:
Subject: Re: wanting to use postgres with python - WHAT am I