[HACKERS] Images in PostgreSQL

2008-03-25 Thread rd 
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,

--
RD | Alea Management  Technology Solutions


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Images in PostgreSQL

2008-03-25 Thread Joshua D. Drake 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tue, 25 Mar 2008 12:06:09 -0300 (BRT)
r[EMAIL PROTECTED] 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-

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Images in PostgreSQL

2008-03-25 Thread Albert Cervera i Areny 
A Dimarts 25 Març 2008, r[EMAIL PROTECTED] 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,

 --
 RD | Alea Management  Technology Solutions



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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers