PostgreSQL是不是没有自增长的那个属性？

scc_166

CREATE SEQUENCE table_id_seq START 10000

CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]
    [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
    [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]

这些都是手册上的. 不明白可以看看手册

longshort

看以下帮助：

1. 
   
2. center=# \h create sequence
   
3. Command:     CREATE SEQUENCE
   
4. Description: define a new sequence generator
   
5. Syntax:
   
6. CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]
   
7.     [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
   
8.     [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
   
9. 
   
10. center=#
    
11. 
    

复制代码

ua

手册啊手册

netkiller

CREATE SEQUENCE "public"."product_id_seq"
    INCREMENT 1  MINVALUE 1
    MAXVALUE 2147483647  START 10000
    CACHE 1;

tigertigger

有，sequence
select 就可以增加1，看看reference里面就有

shonhen

CREATE TABLE cinemas (
        id serial,
        name text,
        location text
) TABLESPACE diskvol1;

hmily36

INTERVAL

diversoft

把当前值设置为10000就行了