Prabu,
There are a number of approaches to do this:
1) Store your images on the file system of the server and in the data
base store only the path to it;
2) Create an icon table, and store your icons as BLOBs in it, then
reference them from your reports table.
I'm not an expert on BLOBs, so please search the message archives for
questions/answers regarding BLOBs (Binary Large Objects - there are
plenty of discussions about them), or read the documentation.
Cheers,
Csaba.
On Mon, 2004-08-02 at 13:08, Prabu Subroto wrote:
> Dear my friends...
>
> My boss requested that my application is equipped with
> emoicon (smiley) in the sales report. That's why I
> need to know, is it possible to save a small image
> into the postgres? with which data type should I
> define the column (field)?
>
> I have a currently table, salesreport. Its fields are
> : noapp (appointment number, int4), salesid (int4),
> custid (customer ID, int4), report (char(150)),
> timestamp (timestamp).
> I want to add a new column into an old table.
> Something in MySQL like this:
> "
> alter table salesreport add column emoicon after
> report
> "
>
> How can I do so on postgres?
>
> Thank you very much in advance.
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - You care about security. So do we.
> http://promotions.yahoo.com/new_mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html