Postgres Pro
Downloads
Home   >   mailing lists

Re: serial field starting at specific value - Mailing list pgsql-novice

From Tom Lane
Subject Re: serial field starting at specific value
Date
Msg-id 7440.1044166405@sss.pgh.pa.us
Whole thread Raw
In response to serial field starting at specific value  (Robert Mosher <mosher@andrews.edu>)
List pgsql-novice
Tree view 
Robert Mosher <mosher@andrews.edu> writes:
> Is there a way I can specify which value a serial field starts at?

Use setval() on the sequence created for the serial column.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Ruslan N. Balkin"
Date:
Subject: Re: PostgreSQL in Arabic
Next
From: Fabio Angeluci Martins
Date:
Subject: Limiting creation of databases