Re: Insert image into bytea question

groberge wrote
> Greetings, all.
>
> This might be a stupid question, but I have not found one good post or
> article on the syntax for inserting an image into a PostgreSQL table
> bytea field on the Internet.
>
> I am currently learning version 9.1, which I had read should work pretty
> well for inserting and retrieving images in the bytea format, but i
> don't know how. I have seen examples of the bytea_import command (which
> I couldn't get to work), and other posts that state that the image must
> be encoded using a "SELECT encode(XXXX)" statement in the query. I had
> originally intended to store the location of the image into a field in
> the database and just pull that reference from the table, and was
> hopeful when I saw that PostgreSQL can handle storing images directly,
> and that it may be even be the preferred method in some cases.
>
> I have been looking online for a couple of hours and have left the Net
> about as confused as when I started! I think that some of the reason is
> that this appears to be a newer method of doing things, and I have been
> reading older information.
>
> Any guidance that anyone can offer would be greatly appreciated.
> George R.

The easiest way is to do things the same way you would store and retrieve a
number or text in your programming language of choice; but of course send
the image bytes variable contents instead of the text variable contents.

There should not be any need to encode/decode if your language provides a
decent API.

You likely do not want to use the large object API (lo_*) but deciding
between data and links requires application and usage knowledge. The main
trade-off is database size (and thus ease of backup/upgrade, etc...) and
administrative overhead synchronizing the data library and the database.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Insert-image-into-bytea-question-tp5802084p5802085.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.