Re: how to alter sequence.

From: "Dan Langille" <dan(at)langille(dot)org>
To: raja kumar thatte <trajakumar(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to alter sequence.
Date: 2002-12-04 12:44:25
Message-ID: 3DEDB259.4378.801560@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raja kumar thatte 2002-12-04 13:20:28 Re: how to alter sequence.
Previous Message raja kumar thatte 2002-12-04 12:29:00 how to alter sequence.

Browse pgsql-hackers by date

  From Date Subject
Next Message raja kumar thatte 2002-12-04 13:20:28 Re: how to alter sequence.
Previous Message Hannu Krosing 2002-12-04 12:37:46 Re: "unofficial" 7.3 RPMs