change datatype in postgres

From: Date: Wed, 23 Jul 2003 22:47:03 +0000
Subject: change datatype in postgres
Groups: php.db 
Request: Send a blank email to php-db+get-29436@lists.php.net to get a copy of this message
I have a table in one of my postgres databases which has a row of type varchar(5). I would like to convert it to varchar(20) data type. Is there an easy way for doing it? I`ve tried to do with this sql sentence "alter table mytable alter column mycolumn varchar(20)", and didn´t works. The table has more than 500 records. It`s something wrong on my query? Thank´s Norma Ramirez Area de Desarrollo Web norma.ramirez@tecnosoft.com.co

« previous php.db (#29436) next »