Re: data-type for image files

Sibu,

> I would like to know if there is a data type for file such as image files.
> In otherwords is there a straignt forward way to place references to
> images-files in a postgres table. I notice there is a network datatype
(cidr
> or inet). If an image file is stored at host://someplace/image for example
> can this 'address' be used as a datatype (i.e. a pointers in the
> table..... ?

Your basic options are these:
1. Use a BLOB datatype to store the images directly in the database.
2. Use filesystem pointers to store the image in a file, which is retrievable
through your interface code.

For a variety of reasons, I prefer 2. However, the BLOB approach as strong
adherents. See the Postgres docs for more info:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/largeobjects.html

-Josh Berkus