Thank´s Xaos, help´s a lot. =>
Regards, Norma R
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Postgresql doesn't support altering the size or data type of a table field.
Prolly the quickest way for you to fix this table is to create another table
the way you want it, with the same fieldnames, but the size you wanted and do
COPY old_tablename
Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a
simple "alter table" like other databases???
and, o.k drop the old column buy copy the data into a new one? how? with an
update query?
Thank´s again and sorry if bother =)
--
PHP Database Mailing List (http://www.php.n
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 h