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: http://postgresql.1045698.n5.nabble.com/Save-and-load-jpg-in-a-PostgreSQL-database-tp3249969p5

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 the

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 fr