Re: customising serial type - Mailing list pgsql-sql

Am Dienstag, 21. Juni 2005 12:01 schrieben Sie:
> hi,in a table with a serial datatype, how do i get the sequence to start at
> a specific number like 100000?


Use START in the create sequence statement.
#

create sequence seq_xeingang increment 1 start 1000;
;

CREATE TABLE xeingang  
(  id            integer default nextval('seq_xeingang'), buch        char not null,  eingdt      date not null, jnr
      integer not null, grp           integer, code          integer not null
 
);



my best regards..

Stefan