Postgres Pro
Downloads
Home   >   mailing lists

Import id column then convert to SEQUENCE? - Mailing list pgsql-general

From gvim
Subject Import id column then convert to SEQUENCE?
Date
Msg-id 4D01A220.7090809@gmail.com
Whole thread Raw
Responses Re: Import id column then convert to SEQUENCE?  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations
Next
From: Shoaib Mir
Date:
Subject: Re: Import id column then convert to SEQUENCE?