asked on Create postgresql sequence for database ids
Hi!
We imported a MySQL database and, since in postgre there isn't Autoincrement options, we need to create a serial.
The thing is, the current exported id's doesn't allow us to change its type from int to a serial, instead of that, Postgresql is asking to create a sequence and set the default value as the nextval of that sequence
Is there any more efficient way to do it?
Regards!
We imported a MySQL database and, since in postgre there isn't Autoincrement options, we need to create a serial.
The thing is, the current exported id's doesn't allow us to change its type from int to a serial, instead of that, Postgresql is asking to create a sequence and set the default value as the nextval of that sequence
Is there any more efficient way to do it?
Regards!
PostgreSQLDatabasesMySQL Server
Last Comment
earth man2
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If you have to do this a ton of times you could try creating a procedure that would take a table and column name as parameters that would do it for you.