Re: I have some questions...

Noo...noo.... I have to put the emoicon (image) into
database and the applications may use them. But your
advise is enough. Your advise solved my problem.

I still have problem with a new column into the
current table (salesreport table). Because I can not
find in the documentation of postgres how to define a
new column into a current table "AFTER A CERTAIN
COLUMN".
on MySQL, I can do easily like this :
"
alter table salesreport add column emoicon(....) after
report;
"
How can I do this on postgres?

Please tell me.

Thank you very much in advance.
--- Michal Taborsky <michal@taborsky.cz> wrote:

> Prabu Subroto wrote:
> > 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)?
>
> What do you mean by "equipped with emoicon (smiley)
> in the sales
> report"? If you are producing some formatted output
> from your data
> stored in database (HTML, PDF, whatever), I suggest
> you add the emoticon
> on application level. You can store some
> representation of the emoticon
> within the text (like ":-)" or ":-(") and then
> substitute this text on
> application level with the image. If you realy want
> to store image data
> in database (which I am not sure is a very good
> idea), you can use
> binary data type, see
>
<http://www.postgresql.org/docs/7.4/static/datatype-binary.html>.
>
> > Something in MySQL like this:
> > "
> > alter table salesreport add column emoicon after
> > report
> > "
>
> Read the manual on ALTER TABLE command
>
<http://www.postgresql.org/docs/7.4/static/sql-altertable.html>.
> You can
> do this easily.
>
> --
> Michal Taborsky
> http://www.taborsky.cz
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
> settings
>




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail