Re: how to alter sequence. - Mailing list pgsql-admin

From Dan Langille
Subject Re: how to alter sequence.
Date
Msg-id 3DEDB259.4378.801560@localhost
Whole thread Raw
In response to how to alter sequence.  (raja kumar thatte <trajakumar@yahoo.com>)
Responses Re: how to alter sequence.  (raja kumar thatte <trajakumar@yahoo.com>)
List pgsql-admin
On 4 Dec 2002 at 4:29, raja kumar thatte wrote:

> Hai friends,
> I have a sequence called raj_seq with max value 3000.
> I have a table, with one field haveing
> nextvalu('raj_seq') as default value.;
> now i wanted to increase the max value of the raj_seq
> to 9999999.
> How to do this change?

http://www.postgresql.org/idocs/index.php?functions-sequence.html
Look for setval
--
Dan Langille : http://www.langille.org/


pgsql-admin by date:

Previous
From: raja kumar thatte
Date:
Subject: how to alter sequence.
Next
From: raja kumar thatte
Date:
Subject: Re: how to alter sequence.