469,628 Members | 1,119 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

Loading Binary Data into Bytea Fields?

I am getting ready to try to add image viewing into my postgresql browser...

I am probably going to start with storing a thumbnail and a URL for the
actual
image in the table.

Is there any demo code for loading binary (actually images...) data into
a bytea field.

The data is going to come from a file....

Jerry

PS: Searching the archives has become painfully slow for me...are there
any mirror
sites that have reasonable response times?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1
1 2535
Hello,

I suggest using large objects over bytea fields.
What language are you using?

Sincerely,

Joshua D. Drake

Jerry LeVan wrote:
I am getting ready to try to add image viewing into my postgresql
browser...

I am probably going to start with storing a thumbnail and a URL for
the actual
image in the table.

Is there any demo code for loading binary (actually images...) data
into a bytea field.

The data is going to come from a file....

Jerry

PS: Searching the archives has become painfully slow for me...are
there any mirror
sites that have reasonable response times?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Alvar Freude | last post: by
reply views Thread by BATISTA | last post: by
4 posts views Thread by Holger Marzen | last post: by
2 posts views Thread by Ron Snyder | last post: by
1 post views Thread by Jerry LeVan | last post: by
4 posts views Thread by Dmitry Teslenko | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.