Search Postgresql Archives

Re: [SQL] How to Convert Integer to Serial

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: venkat <ven.tammineni@xxxxxxxxx>
Subject: Re: [SQL] How to Convert Integer to Serial
From: Shoaib Mir <shoaibmir@xxxxxxxxx>
Date: Fri, 29 Oct 2010 16:01:40 +1100
Cc: pgsql-general@xxxxxxxxxxxxxx, pgsql-sql@xxxxxxxxxxxxxx
In-reply-to: <AANLkTim-ZxOQStJenijn2UgMomM__PoFYKMrUzFeyE5x@xxxxxxxxxxxxxx>

On Fri, Oct 29, 2010 at 3:58 PM, venkat <ven.tammineni@xxxxxxxxx> wrote:

Dear All,

I got the solution... Here is my query

ALTER TABLE DemoTable ALTER gid TYPE INT2;

Are you sure that you have converted here to a SERIAL type?

--
Shoaib Mir
http://shoaibmir.wordpress.com/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- How to Convert Integer to Serial
  - From: venkat
- Re: How to Convert Integer to Serial
  - From: venkat

Prev by Date: Re: [SQL] How to Convert Integer to Serial
Next by Date: Re: [SQL] How to Convert Integer to Serial
Previous by thread: Re: How to Convert Integer to Serial
Next by thread: Re: [SQL] How to Convert Integer to Serial
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux