Thread: Storing Photographs in Postgres?
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.
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/