Re: How to Convert Integer to Serial

From: venkat <ven(dot)tammineni(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to Convert Integer to Serial
Date: 2010-10-29 04:58:24
Message-ID: AANLkTim-ZxOQStJenijn2UgMomM__PoFYKMrUzFeyE5x@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(dot)tammineni(at)gmail(dot)com> wrote:

> Dear All,
>
> I want to convert integer datatype to serial datatype.. is that
> possible.Please let me know.
>
> Thanks and Regards,
>
> Ven
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-10-29 04:58:53 Re: Adivice on master - master replication.
Previous Message venkat 2010-10-29 04:48:53 How to Convert Integer to Serial

Browse pgsql-sql by date

  From Date Subject
Next Message Shoaib Mir 2010-10-29 05:00:16 Re: [SQL] How to Convert Integer to Serial
Previous Message venkat 2010-10-29 04:48:53 How to Convert Integer to Serial