you can convert from type to type using ::varchar or ::char(size) or ::integer
so you can use sequence but you will have to convert it's result to suitable type (that can also be put in default value of user_id attribute)
On Fri, May 11, 2012 at 9:30 PM, Carlos Mennens
<carlos.mennens@gmail.com> wrote:
Thanks for all the help thus far everyone! I sadly didn't
create/design the table and would love to create a SEQUENCE on that
particular field but not sure how unless I DROP the table and create
from scratch.
Currently the data TYPE on the primary key field (users_id) is CHAR
and I have no idea why...it should be NUMERIC or SERIAL but it's not
so my question is if I want to ALTER the column and create a sequence,
would I simply do:
ALTER TABLE users
ALTER COLUMN users_id TYPE serial
;
Obviously if any of the data stored in users_id is actual CHAR, I'm
guessing the database would reject that request to change type as the
existing data would match. However the data type is CHAR but the field
values are all numeric from 1000000010 - 1000000301 so I'm hoping that
would work for SERIAL which is just INTEGER, right?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
