On Wed, Aug 19, 2009 at 6:20 PM, Aras Angelo<araskok...@gmail.com> wrote: > Im trying to alter a column type from character varying(8) to int. > All the values in the column are numbers but im getting this message > > column "xxxxxx" cannot be cast to type integer > > Dropping and readding the column is an option but downtime is very critical > to us, so i was wondering > if im doing something wrong and i can alter type somehow.
alter table xyz alter COLUMN i type int using i::int; Note that this will fail if any of the entries in teh column i are not ints. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
