Re: handling images in postgresql

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Ramon Orticio <rporticio(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: handling images in postgresql
Date: 2005-02-17 13:02:16
Message-ID: 265D7A70-80E4-11D9-A3A1-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Feb 17, 2005, at 2:03 AM, Ramon Orticio wrote:

> how do you enter files of images such as jpeg and
> bitmaps in postgresql.

You can create a column with type bytea or use the large object
functions.

http://www.postgresql.org/docs/8.0/interactive/datatype-binary.html
http://www.postgresql.org/docs/8.0/interactive/largeobjects.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jesus Lopez 2005-02-17 13:50:46 error using COPY command
Previous Message Bo Lorentsen 2005-02-17 07:22:41 Re: Front End Languages for PostgreSQL