Re: Save and load jpg in a PostgreSQL database - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Save and load jpg in a PostgreSQL database
Date
Msg-id AANLkTin+rbkbU-TTFNcSYpQobKBtW7LXzsAVpiAXEtEO@mail.gmail.com
Whole thread Raw
In response to Save and load jpg in a PostgreSQL database  (lfmartinelli <luis.fernando.martinelli@gmail.com>)
Responses Re: Save and load jpg in a PostgreSQL database  (lfmartinelli <luis.fernando.martinelli@gmail.com>)
List pgsql-general
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 ?

2010/11/4 lfmartinelli <luis.fernando.martinelli@gmail.com>

Hi,

My name is Fernando, i work with C# and PostgreSQL. I need save a jpg in a
PostgreSQL table.
How do i this? I read in a forum to use this to save in database:

INSERT INTO table (image) VALUES (pg_escape_bytea(image.jpg))

Don't i need convert image file to binary before save in a database?
How get i this image to a variable using c#?

Please help me!

Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Save-and-load-jpg-in-a-PostgreSQL-database-tp3249969p3249969.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


pgsql-general by date:

Previous
From: Michael Gould
Date:
Subject: Re: Linux
Next
From: Christopher Farah
Date:
Subject: Installing PostgreSQL on Windows 7 64-bit system