Re: Images in PostgreSQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: r&d(at)alea(dot)inf(dot)br
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Images in PostgreSQL
Date: 2008-03-25 15:26:26
Message-ID: 20080325082626.59de9017@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

On Tue, 25 Mar 2008 12:06:09 -0300 (BRT)
r&d(at)alea(dot)inf(dot)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-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Albert Cervera i Areny 2008-03-25 15:27:37 Re: Images in PostgreSQL
Previous Message Simon Riggs 2008-03-25 15:11:03 Re: FETCH FIRST