I won't say what is right or wrong to do. But some will say to store the
file location in a field such as /mydocs/mypictures/myimage.jpg and then
have your php or what ever open that file. by using a select statement.
Not sure how you would store them in the database and pull it righ out. I
would prefer your method for many reasons. For one backing up the database
also backups up all your image files. Good luck.
|---------+---------------------------------->
| | "C G" |
| | <[EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | tgresql.org |
| | |
| | |
| | 04/05/2004 11:20 AM |
| | |
|---------+---------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: [GENERAL] Storing jpgs
|
>------------------------------------------------------------------------------------------------------------------------------|
Dear All,
What's the best way to store jpgs in postgresql to use in a web page?
I tried to use large objects, but how would you extract them from a table
to
be viewed in a web-page without having to write them to a scratch file
somewhere first?
Thanks
Colin
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the
exclusive use of addressee and may contain proprietary, confidential and/or privileged
information. If you are not the intended recipient, any use, copying, disclosure,
dissemination or distribution is strictly prohibited. If you are not the intended
recipient, please notify the sender immediately by return e-mail, delete this
communication and destroy all copies.
*************************************************************************
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
