Horton
Menu

Thread

  1. Storing Photographs in Postgres?

    B.N.V. Raman <raman@myself.com> — 2001-04-14T15:57:15Z

    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.

  2. Re: Storing Photographs in Postgres?

    Dennis Fleurbaaij <dennis@core-lan.nl> — 2001-04-14T23:09:20Z

    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

  3. Re: Storing Photographs in Postgres?

    Peter T Mount <peter@retep.org.uk> — 2001-04-20T10:37:21Z

    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/