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 > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
