| From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
|---|---|
| To: | "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Changing data types |
| Date: | 2001-09-24 14:40:23 |
| Message-ID: | Pine.BSO.4.10.10109241039520.28103-100000@spider.pilosoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
This is not for -hackers.
And the answer is "no, you can't". Recreate the table with correct types
and insert the old values into it.
On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
> I posted this in my last message, but have not heard anything yet so I'm
> wondering if it was overlooked. I need to know how to change a column from
> being say a varchar(9) to an integer. Does anyone know how to change the
> data type?
>
> Geoff
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gowey, Geoffrey | 2001-09-24 14:53:02 | Re: Changing data types |
| Previous Message | Marc G. Fournier | 2001-09-24 14:22:28 | Re: anoncvs failure... |