Import image into postgresql database

From: "francescoboccacci(at)libero(dot)it" <francescoboccacci(at)libero(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Import image into postgresql database
Date: 2011-07-01 10:13:33
Message-ID: 8011192.5657131309515213054.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gabriele Bartolini 2011-07-01 10:27:31 Re: Import image into postgresql database
Previous Message Dave Pooser 2011-07-01 07:23:53 Help compiling --with-ldap on Solaris 11 Express?