Postgres Pro
Downloads
Home   >   mailing lists

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

From gvim
Subject Import ID column data then convert to SEQUENCE?
Date
Msg-id 4D01A021.9020205@gmail.com
Whole thread Raw
Responses Re: Import ID column data then convert to SEQUENCE?  (John R Pierce <pierce@hogranch.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
createthe `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

pgsql-general by date:

Previous
From: "Jaiswal Dhaval Sudhirkumar"
Date:
Subject: Re: calculation of database size
Next
From: John R Pierce
Date:
Subject: Re: Import ID column data then convert to SEQUENCE?