CREATE SEQUENCE test_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; ALTER TABLE test_id_seq OWNER TO admin; CREATE TABLE test ( id bigserial NOT NULL, data character varying(128) NOT NULL, CONSTRAINT pkey_id_test PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE test OWNER TO admin; CREATE OR REPLACE RULE replace_test AS ON INSERT TO test WHERE (EXISTS ( SELECT 1 FROM test WHERE test.id = new.id)) DO INSTEAD UPDATE test SET data = new.data WHERE test.id = new.id; ALTER TABLE test ADD CONSTRAINT pkey_id_test PRIMARY KEY(id); ALTER TABLE test ADD COLUMN id bigint; ALTER TABLE test ALTER COLUMN id SET STORAGE PLAIN; ALTER TABLE test ALTER COLUMN id SET NOT NULL; ALTER TABLE test ALTER COLUMN id SET DEFAULT nextval('test_id_seq'::regclass); ALTER TABLE test ADD COLUMN data character varying(128); ALTER TABLE test ALTER COLUMN data SET STORAGE EXTENDED; ALTER TABLE test ALTER COLUMN data SET NOT NULL;
INSERT INTO "test" ("data") VALUES ('1')
SELECT "id" FROM "test" ORDER BY "id"
2 5 10 17 26 37 50
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)