On Fri, May 11, 2012 at 3:44 PM, Thomas Kellerer <spam_ea...@gmx.net> 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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
