Unix Technical Forum

handling images in postgresql

This is a discussion on handling images in postgresql within the pgsql Novice forums, part of the PostgreSQL category; --> how do you enter files of images such as jpeg and bitmaps in postgresql. thanks __________________________________ Do you Yahoo!? ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:30 PM
Ramon Orticio
 
Posts: n/a
Default handling images in postgresql

how do you enter files of images such as jpeg and
bitmaps in postgresql.

thanks





__________________________________
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 08:30 PM
John DeSoi
 
Posts: n/a
Default Re: handling images in postgresql


On Feb 17, 2005, at 2:03 AM, Ramon Orticio wrote:

> how do you enter files of images such as jpeg and
> bitmaps in postgresql.


You can create a column with type bytea or use the large object
functions.

http://www.postgresql.org/docs/8.0/i...pe-binary.html
http://www.postgresql.org/docs/8.0/i...geobjects.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:15 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com