| From: | Prabu Subroto <prabu_subroto(at)yahoo(dot)com> |
|---|---|
| To: | Postgres General Milis <pgsql-general(at)postgresql(dot)org> |
| Subject: | I have some questions... |
| Date: | 2004-08-02 11:08:48 |
| Message-ID: | 20040802110848.25273.qmail@web41811.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2004-08-02 11:38:10 | Re: I have some questions... |
| Previous Message | Janning Vygen | 2004-08-02 10:12:38 | Re: How to use as Functional Index to be used as Primary KEY |