Import id column then convert to SEQUENCE?

From: gvim <gvimrc(at)gmail(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Import id column then convert to SEQUENCE?
Date: 2010-12-10 03:44:32
Message-ID: 4D01A220.7090809@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

gvim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2010-12-10 03:53:08 Re: Import id column then convert to SEQUENCE?
Previous Message gvim 2010-12-10 03:36:01 Import ID column data then convert to SEQUENCE?