> HI Milen,
> Thanks for your great response,I do not find anything like insert
> images.. I have seen the whole tutorial..Please can you give me some
> example to insert images into postgresql.
> I am waiting for your great response.
PostgreSQL has a general binary datatype called "bytea". There is no
specific data type of "image", "jpg", "png", etc.
It is up to you to read the binary data, be it images, audio, or
whatever and store them in your "bytea" column. As previously suggested,
scroll down to the part titled "Working with binary data and bytea
datatype" and try the example code there. Just feed it your images as
input and all should be good.
In response to
pgsql-sql by date
|Next:||From: Bryce Nesbitt||Date: 2008-12-19 05:46:45|
|Subject: index compatible date_trunc in postgres?|
|Previous:||From: venkat||Date: 2008-12-18 14:44:58|
|Subject: Re: Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net|