Storing Photographs in Postgres?

That's what a BLOB type is invented for.

Cheers,
Dennis Fleurbaaij

"B.N.V. Raman" wrote:

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?

Regards,

Raman.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
Met vriendelijke groet,

Dennis Fleurbaaij
Stichting CORE http://www.core-lan.nl
Tel: +31 (0)6 54 21 53 65
Fax: +31 (0)20 86 47 059

Quoting "B.N.V. Raman" <raman@myself.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@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/