From: | "Development - multi(dot)art(dot)studio" <dev(dot)null(at)multiartstudio(dot)com> |
---|---|
To: | Guy Fraser <guy(at)incentre(dot)net> |
Cc: | "Taber, Mark" <Mark(dot)Taber(at)dof(dot)ca(dot)gov>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: BLOB help needed... |
Date: | 2004-04-27 23:10:40 |
Message-ID: | 408EE870.9070302@multiartstudio.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i wrote a php skript to test this, works beautiful,
you can download the script at
http://www.erdtrabant.de/index.php?i=500200104
volker
Guy Fraser wrote:
> If you are using php, the two functions below should help.
>
> http://ca.php.net/manual/en/function.pg-escape-bytea.php
> http://ca.php.net/manual/en/function.pg-unescape-bytea.php
>
> Taber, Mark wrote:
>
>> We’re implementing our first PostgreSQL database, and enjoying it
>> very much. However, we have a table that will store binary image
>> files (pie charts, etc.) for later display on a dynamic webpage.
>> While we’re putting together our prototype application, I’ve been
>> asked by the programmers (I’m the DBA) to “put the images in the
>> database.” I can see how to do this using Large Objects, but then
>> getting them out again seems problematic, and the documentation is a
>> bit sketchy. Would BYTEA columns be better? However, it seems to me
>> that there is no easy way using psql to load images into a BYTEA
>> column. Any help would be greatly appreciated.
>>
>> Regards,
>>
>> Mark Taber
>>
>> State of California
>>
>> Department of Finance
>>
>> Infrastructure & Architecture Unit
>>
>> 916.323.3104 x 2945
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Hirt | 2004-04-27 23:17:18 | locking question |
Previous Message | Devrim GUNDUZ | 2004-04-27 23:03:01 | Cannot open relation pg_cast_source_target_index |