On Tuesday 21 June 2005 13:01, you wrote:
> hi,
> in a table with a serial datatype, how do i get the sequence to start
> at a specific number like 10?
ALTER SEQUENCE sequence_name RESTART WITH 10;
--
Krasimir Dimitrov
IT Departme
hi,
in a table with a serial datatype, how do i get the sequence to start
at a specific number like 10?
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
---(end of broadcast)---
TIP 7: don't
On Jun 21, 2005, at 7:01 PM, Kenneth Gonsalves wrote:
in a table with a serial datatype, how do i get the sequence to start
at a specific number like 10?
The SERIAL datatype (e.g., CREATE TABLE foo(foo_id SERIAL) )is a
shorthand for something like
CREATE SEQUENCE foo_id_seq;
CREATE TAB
