postgresql 主键自增，以及mybaits 逆向生成

CREATE SEQUENCE event_id_seq  
START WITH 1  
INCREMENT BY 1  
NO MINVALUE  
NO MAXVALUE  
CACHE 1;  
  
alter table event alter column id set default nextval(‘event_id_seq‘);  

<jdbcConnection driverClass="org.postgresql.Driver"
                        connectionURL="jdbc:postgresql://l-***.com:5433/crm"
                        userId="menpiao_dev" password="d**904-8dce-**d0-bb1b-79***cc">
 </jdbcConnection>