CREATE SEQUENCE next_item start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; или CREATE SEQUENCE next_item; CREATE TABLE item ( "id" integer DEFAULT nextval('next_item') PRIMARY KEY, ..... );