Import image into postgresql database
От | francescoboccacci@libero.it |
---|---|
Тема | Import image into postgresql database |
Дата | |
Msg-id | 8011192.5657131309515213054.JavaMail.defaultUser@defaultHost обсуждение исходный текст |
Ответы |
Re: Import image into postgresql database
|
Список | 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
В списке pgsql-admin по дате отправления: