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.tammineni@xxxxxxxxx> wrote:
Dear All,I want to convert integer datatype to serial datatype.. is that possible.Please let me know.
Thanks and Regards,Ven