Thread: Import id column then convert to SEQUENCE?

I'm migrating a database from MySQL and need to keep the original `id` column (AUTO_INCREMENT) intact so my plan is to
createan simple integer `id` column, import the data then convert the new `id` column to a SEQUENCE. Is this
possible/thebest solution? Maybe a migration utility would be better? Suggestions? 

gvim

On Thu, Dec 9, 2010 at 10:56 PM, Shoaib Mir <shoaibmir@gmail.com> wrote:
> I guess I misread it... use the following:
>
> - Import all the data into say an integer column.
> - Now create a sequence and give it a start value of where your import
> ended.
> - Make the default value for the column using the new sequence.
>

create the table with a SERIAL column, which will make the sequence
and set the auto increment default as you wanted.

import the data

update the sequence with setval() to the next highest value you want
it to return, usually max()+1 of the populated column.