Re: Insert ImageFile in PostgreSQL

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>