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,
	.....
);