Re: [GENERAL] How to Convert Integer to Serial

2010-10-28 Thread John R Pierce
On 10/28/10 9:48 PM, venkat wrote: Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know. SERIAL is not actually a data type, its simply an integer with an associated sequence.what Shoab Mir gave will add this sequence to the existing

Re: [GENERAL] How to Convert Integer to Serial

2010-10-28 Thread venkat
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 wrote: > Dear All, > > I want to convert integer datatype to serial datatype.. is that > possible.Please let me know. > > Thanks and Rega