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
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