Re: Storing Photographs in Postgres?

Quoting "B.N.V. Raman" <raman(at)myself(dot)com>:

> Hi All,
>
> Is there a way to store photographs in postgres? I'm creating an
> employee
> master kind of thing, so i would like to store photos of my company
> employees also. If there is, is there a file size limitation or
> something?

Yes, although normaly it's a better design thing to keep them outside and have
references to them. It depends on how you are accessing & using the data.

There's an example Java app under /src/interfaces/jdbc.

As for file size limit, in theory no. In practice, its a design issue for your
application etc.

Peter (7 days behind on emails :-( )

--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/