Home > mailing lists

Re: [SQL] How to Convert Integer to Serial - Mailing list pgsql-general

From	Shoaib Mir
Subject	Re: [SQL] How to Convert Integer to Serial
Date	October 29, 2010 05:01:55
Msg-id	AANLkTim55Uz34D3AvOX1xOFahvE1zzPHjdXygReg3JoT@mail.gmail.com Whole thread Raw
In response to	Re: How to Convert Integer to Serial (venkat <ven.tammineni@gmail.com>)
List	pgsql-general

On Fri, Oct 29, 2010 at 3:58 PM, venkat <ven.tammineni@gmail.com> wrote:

Dear All,

I got the solution... Here is my query

ALTER TABLE DemoTable ALTER gid TYPE INT2;

Are you sure that you have converted here to a SERIAL type?

From: Shoaib Mir
Date: 29 October 2010, 05:00:30
Subject: Re: [SQL] How to Convert Integer to Serial

From: venkat
Date: 29 October 2010, 05:02:30
Subject: Re: [SQL] How to Convert Integer to Serial