| From: | Howie <caffeine(at)toodarkpark(dot)org> |
|---|---|
| To: | rob caSSon <rob(at)styro(dot)lib(dot)muohio(dot)edu> |
| Cc: | kaiq(at)realtyideas(dot)com, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re:[OT]-[SQL] manually set serial type |
| Date: | 1999-12-17 08:18:00 |
| Message-ID: | Pine.LNX.3.96.991217081524.25654I-100000@rabies.toodarkpark.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)toodarkpark(dot)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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Margarit Nickolov | 1999-12-17 09:43:41 | Re: [SQL] adding time to a datetime field ... how? |
| Previous Message | Peter Eisentraut | 1999-12-17 00:31:01 | Re: [SQL] adding time to a datetime field ... how? |