Hey Dmitriy,
I'm using Visual Studio 2010 system.data.odbc becouse this worked good and i tested psqlodbc lib to .Net, but i don't find any advantage to use this.
In a Brazilian forum, i read a post and it was written:
-" Just use this line: INSERT INTO table (image) VALUES (pg_escape_bytea(
image.jpg))".
Changing "image.jpg" to my image file, the PostgreSQL already convert this and save in a database.
Is this true? And how can i load this to imageBox in my system? Which type must be declared my variable?
Thanks to your help.
Em 04/11/2010 15:40, Dmitriy Igrishin [via PostgreSQL] escreveu:
Hey Fernando,
If you need to store binary data in a table you should use bytea data type.
Than, in case of libpq:
If you want to transmit binary data from client to server in text format you
must prepare (escape) it for including into you SQL command (e.g., INSERT).
If you can transmit the data from client to server in binary format you don't
need escape you binary data, but you must tell libpq (or the library you use)
that you transmission will be in a binary format.
What library do you use to work with PostgreSQL ?
--
// Dmitriy.
View this message in context:
Re: Save and load jpg in a PostgreSQL database Sent from the
PostgreSQL - general mailing list archive at Nabble.com.