Am Dienstag, den 02.08.2005, 08:52 -0700 schrieb silasju@xxxxxxxxx:
> 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@xxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
