Home > mailing lists

Re: How to Convert Integer to Serial - Mailing list pgsql-sql

From	venkat
Subject	Re: How to Convert Integer to Serial
Date	October 29, 2010 04:58:34
Msg-id	AANLkTim-ZxOQStJenijn2UgMomM__PoFYKMrUzFeyE5x@mail.gmail.com Whole thread Raw
In response to	How to Convert Integer to Serial (venkat <ven.tammineni@gmail.com>)
Responses	Re: How to Convert Integer to Serial (Shoaib Mir <shoaibmir@gmail.com>)
List	pgsql-sql

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.tammineni@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

From: venkat
Date: 29 October 2010, 04:49:04
Subject: How to Convert Integer to Serial

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