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;