Re: migrating numeric to serial from MSSQL to postgres - Mailing list pgsql-sql

> hi,
> 
> am migrating a database from MSSQL to postgres. How would i migrate
> this:
> 
> [Id] [numerc](18, 0) IDENTITY (1, 1)
> 

You might want to create a sequence first, such as with more or less
options:

CREATE SEQUENCE my_sequence INCREMENT BY 1 MINVALUE 1 NO MAXVALUE START WITH 1 CACHE 1 NO CYCLE;

Then you should be able to migrate your code to something like:
 Id INTEGER NOT NULL DEFAULT NEXTVAL(my_sequence')

--
Daniel