On Fri, May 11, 2012 at 3:44 PM, Thomas Kellerer <[email protected]> wrote: > Use this: > > alter table users > alter column users_id type integer using to_number(users_id, '99999'); > > (Adjust the '99999' to the length of the char column)
When you wrote "Adjust the '99999' to the length of the char column, do you mean change '99999' to '312' if my last used maximum value was 312? So the next sequence primary key value would be '313', right? -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
