Re: migrating numeric to serial from MSSQL to postgres

From: Daniel CAUNE <d(dot)caune(at)free(dot)fr>
To: 'Kenneth Gonsalves' <lawgon(at)thenilgiris(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: migrating numeric to serial from MSSQL to postgres
Date: 2006-10-15 13:49:55
Message-ID: 000f01c6f060$cbd505e0$0b00a8c0@tedy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Fielder 2006-10-15 13:54:45 Re: migrating numeric to serial from MSSQL to postgres
Previous Message Kenneth Gonsalves 2006-10-15 13:05:47 migrating numeric to serial from MSSQL to postgres