Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9R1ZmP66919 for ; Fri, 26 Oct 2001 21:35:48 -0400 (EDT) (envelope-from pgsql@symcom.com) Message-Id: <200110270135.f9R1ZmP66919@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Fri, 26 Oct 2001 21:44:56 -0400 Date: Fri, 26 Oct 2001 21:44:56 -0400 From: "postgresql" To: "PgSQL-SQL" Subject: serial data type X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200110/379 X-Sequence-Number: 5331 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