I have some questions... - Mailing list pgsql-general

From Prabu Subroto
Subject I have some questions...
Date
Msg-id 20040802110848.25273.qmail@web41811.mail.yahoo.com
Whole thread Raw
Responses Re: I have some questions...  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: I have some questions...  (Michal Taborsky <michal@taborsky.cz>)
List 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

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Re: How to use as Functional Index to be used as Primary KEY
Next
From: Csaba Nagy
Date:
Subject: Re: I have some questions...