Re:[OT]-[SQL] manually set serial type - Mailing list pgsql-sql

From Howie
Subject Re:[OT]-[SQL] manually set serial type
Date
Msg-id Pine.LNX.3.96.991217081524.25654I-100000@rabies.toodarkpark.org
Whole thread Raw
In response to Re:[OT]-[SQL] manually set serial type  (rob caSSon <rob@styro.lib.muohio.edu>)
List pgsql-sql
On Thu, 16 Dec 1999, rob caSSon wrote:

> yeah...i'll scour the mboxes, although i'm actually using netscrape 4.7 on
> a debian box....;-)

select setval(sequence_name,value);

ie:

select setval( 'groups_seq', 89231 );

\df via psql shows:

result|function    |arguments       |description
------+------------+----------------+-------------------------
...
int4  |setval      |text int4       |sequence set value
...

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org    
"I've learned that you cannot make someone love you.  All you can do is stalk them and hope they panic and give in."



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] adding time to a datetime field ... how?
Next
From: Margarit Nickolov
Date:
Subject: Re: [SQL] adding time to a datetime field ... how?