Message-ID: <8011192.5657131309515213054.JavaMail.defaultUser@defaultHost>
Date: Fri, 1 Jul 2011 12:13:33 +0200 (CEST)
From: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
Reply-To: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
To: pgsql-admin@postgresql.org
Subject: Import image into postgresql database
MIME-Version: 1.0
Content-Type: text/plain;charset="UTF-8"
Content-Transfer-Encoding: 7bit

Dear all,
i have a question for you: I would like to store  images (jpg) into a table of 
postgresql database. My question is : what is the corret type of tables filed 
that i have to use? Reading some forum of article in the net there are two 
ways: bytea or oid type. Whati is the best type to store my images?
I tried to insert in both ways. With oid type i able to insert images, but 
with bytea i don't understand how store it .
i create a test table:

CREATE TABLE public.images
(
  imgname text,
  img bytea
)

and i tried many ways:


NSERT INTO images (imgname, img)
VALUES ('beautiful image', bytea_import('C:\\9999.jpg'));

or 
 
INSERT INTO  images (img) VALUES (pg_escape_bytea('C:\\9999.jpg'))

but it doesn't work.
So How can i solve my problem? and another question.. If i able to store my 
image into bytea fiels..how can i export it for see it for example with paint?

Thanks

Francesco Boccacci