serial data type - Mailing list pgsql-sql

From postgresql
Subject serial data type
Date
Msg-id 200110270135.f9R1ZmP66919@postgresql.org
Whole thread Raw
Responses Re: serial data type  (David Stanaway <david@netventures.com.au>)
List pgsql-sql
CREATE TABLE tablename (colname SERIAL);

okay, but how do I set the beginning number. So far the only thing I 
have been able to do is directly after creating the serial column, I do:

select setval('tablename_colname_seq', 15753);

Is this the only way to set the beginning number of a sequence? 

Thanks for all your help guys,

Ted Petrosky
tedpet@symcom.com




pgsql-sql by date:

Previous
From: "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков
Date:
Subject: Re: GUID in postgres
Next
From: David Stanaway
Date:
Subject: Re: serial data type