Обсуждение: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

Dear All,<br /><br />  I want   to insert Images(bnp,png,etc) into Postgresql and how to retrieve the inserted Imaged
usingC#.net.I do not know where to start? Any one can help me.<br /><br /> I am waiting for your great response.<br
/><br/>Advanced Thanks,<br />Venkat.<br /><br /><br clear="all" /><br /> 

venkat написа:
> Dear All,
> 
>   I want   to insert Images(bnp,png,etc) into Postgresql and how to retrieve
> the inserted Imaged using C#.net.I do not know where to start? Any one can
> help me.
[...]

Start here  -
http://npgsql.projects.postgresql.org/docs/manual/UserManual.html and
look for "Working with binary data and bytea datatype".


-- 
Milen A. Radev

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.

Thanks,
Venkat.




--
Thanks And Regards,
VENKATRAO TAMMINENI

venkat wrote:
> 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.

Cheers,
Steve