Try looking at SEQUENCE

CREATE SEQUENCE member_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
CACHE 1;

And you can get the next id:

SELECT nextval('member_id_seq');