Postgres Pro
Downloads
Home   >   mailing lists

Thread: Storing .jpg files

Storing .jpg files

From
john-paul delaney
Date:
What field data type do I use to store .jpg's?

thanks
/j-p.


-----------------------
 JUSTATEST Art Online
  www.justatest.com

Re: Storing .jpg files

From
"Joshua b. Jore"
Date:
-----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-----

Re: Storing .jpg files

From
"Henshall, Stuart - WCP"
Date:
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
>