Dear All, I got the solution... Here is my query
ALTER TABLE DemoTable ALTER gid TYPE INT2; Thanks again.... On Fri, Oct 29, 2010 at 10:18 AM, venkat <ven.tammin...@gmail.com> wrote: > Dear All, > > I want to convert integer datatype to serial datatype.. is that > possible.Please let me know. > > Thanks and Regards, > > Ven >