Or alternatively use the bytea type (although you can't do any chunk editing
with this)
Cheers,
- Stuart
> -----Original Message-----
> From: Joshua b. Jore [mailto:josh@greentechnologist.org]
> Sent: 23 April 2002 22:25
> To: john-paul delaney
> Cc: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] Storing .jpg files
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> You would either store them on the file system or as blobs
> and then track
> the OIDs with the type OID..
>
> Joshua b. Jore
> http://www.greentechnologist.org
>
> On Tue, 23 Apr 2002, john-paul delaney wrote:
>
> > What field data type do I use to store .jpg's?
> >
> > thanks
> > /j-p.
> >
> >
> > -----------------------
> > JUSTATEST Art Online
> > www.justatest.com
> >
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (OpenBSD)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE8xdEkfexLsowstzcRAgpSAKDW2GZVY/KOeiBn6ZAL28tHiHrDwQCeNJ8z
> Aim6la7b4VwiY9FkNIU9xtY=
> =tZ01
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>