serial data type

From: "postgresql" <pgsql(at)symcom(dot)com>
To: "PgSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: serial data type
Date: 2001-10-27 01:44:56
Message-ID: 200110270135.f9R1ZmP66919@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)symcom(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Johnny Predicto 2001-10-27 07:29:27 PostgreSQL, Java & JDBC
Previous Message Jack 2001-10-27 00:18:12 Problems of Temporary table