| From: | Peter Landis <ntwebdeveloper(at)yahoo(dot)com> |
|---|---|
| To: | postgreSQL general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | ALTERING A TABLE |
| Date: | 2000-06-01 16:11:59 |
| Message-ID: | 20000601161159.14326.qmail@web3205.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi-
I'm a newbie at postgresql and ran into a
situation on trying to alter an element in a table. I
have a table called company where a field is called
address. The address field is set to char() 20 and I
want to alter the value to have an address field of
100. What would be the command to alter the table to
change this field without affecting the data? If
anyone could help I would greatly appreciate it.
Thanks,
Mr. Newbie
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merrill Oveson | 2000-06-01 16:21:20 | deferred capability for the primary key |
| Previous Message | Ron Peterson | 2000-06-01 13:49:56 | Re: Re: Speed of locating tables |