PostgreSQL 序列增删改案例_PostgreSQL_

 CREATE SEQUENCE if not exists test_mergetable_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1; //或者： create sequence if not exists test_mergetable_id_seq increment by 1 minvalue 1 no maxvalue start with 1; 

 alter table test_mergetable alter column "i_id" set default nextval('test_mergetable_id_seq');

 SELECT setval('test_mergetable_id_seq', (SELECT MAX(i_id) FROM test_mergetable)); alter sequence test_mergetable_id_seq start with 12;

 drop sequence IF EXISTS test_mergetable_id_seq

 SELECT nextval('test_mergetable_id_seq')

 create user user1;

 alter user report with password 'password';

 grant usage on schema schema1 to user1; grant usage on schema schema2 to user1;

 set search_path = "$user",user1,user2

 grant all on schema schema1 to user1;

 grant all on all tables in schema schema1 to user1;

 grant all on all tables in schema schema1 to user1;

 grant select on schema2.table1 to user1;

 revoke all on all tables in schema schema1 from user1;

 alter user user1 set search_path="$user",user1,user2;