| From: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> |
|---|---|
| To: | Judith <jaltamirano(at)correolux(dot)com(dot)mx> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Change of data type |
| Date: | 2006-08-08 11:51:56 |
| Message-ID: | 20060808115156.GA8393@dagan.sigpipe.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
# jaltamirano(at)correolux(dot)com(dot)mx / 2006-08-07 12:38:20 -0500:
> Hello everybody, excuse me how can I change de data type of a field,
> I currently have:
>
> material character(30)
>
> but I now want the field in text type like this:
>
> material text
>
> somebody knows if ALTER TABLE has some option to do this?, or How
> can I do that?
http://www.postgresql.org/docs/8.1/static/sql-altertable.html
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Sinclair | 2006-08-08 12:25:47 | Query response time |
| Previous Message | Kumar Dev | 2006-08-07 20:45:43 | Re: Change of data type |