Thread: Images in PostgreSQL

Hi all,

Does anybody know if is it possible to store images in Postgre? If it is
possible which data type should I use?

Thanks in advance,

--
R&D | Alea Management & Technology Solutions

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 25 Mar 2008 12:06:09 -0300 (BRT)
r&d@alea.inf.br wrote:

> Hi all,
> 
> Does anybody know if is it possible to store images in Postgre? If it
> is possible which data type should I use?

There are two ways to do it:

http://www.postgresql.org/docs/8.3/static/datatype-binary.html
http://www.postgresql.org/docs/8.3/static/lo-funcs.html

Sincerely,

Joshua D. Drake


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH6RmiATb/zqfZUUQRAhsOAJ9dDzb47p2n2hnIInZhhgXdT66TagCfYi2t
emUwHcomGeBzHMx0miHieD0=
=6bdP
-----END PGP SIGNATURE-----

A Dimarts 25 Març 2008, r&d@alea.inf.br va escriure:
> Hi all,
>
> Does anybody know if is it possible to store images in Postgre? If it is
> possible which data type should I use?
>

Yes it's possible, you can use BYTEA for this, for example. But please, this 
kind of questions should go to users mailing list. hackers is for people 
working on developing PostgreSQL itself.

> Thanks in advance,
>
> --
> R&D | Alea Management & Technology Solutions



-- 
Albert Cervera i Areny
http://www.NaN-tic.com