Re: [GENERAL] Save and load jpg in a PostgreSQL database

2012-02-07 Thread bonave
C# Insert image http://net-informations.com/csprj/dataset/cs-insert-image.htm C# retrieve image http://net-informations.com/csprj/dataset/cs-retrieve-image.htm bn. -- View this message in context:

Re: [GENERAL] Save and load jpg in a PostgreSQL database

2010-11-06 Thread Dmitriy Igrishin
Hey Fernando, There is no pg_escape_bytea() in PostgreSQL. It seem like a function of some PL, like PHP or Tcl... So, the command that you found on a forum is incorrect. As I understand, you want to upload a file from your (client) filesystem to the PostgreSQL database (server) and store it in

Re: [GENERAL] Save and load jpg in a PostgreSQL database

2010-11-04 Thread Dmitriy Igrishin
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