CREATE SEQUENCE POSTGRES FOR EXISTING TABLE

gistfile1.txt

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

ALTER TABLE public."TYPES_typeid_seq" OWNER TO postgres;
ALTER SEQUENCE "TYPES_typeid_seq" OWNED BY "TYPES".typeid;
ALTER TABLE ONLY "TYPES" ALTER COLUMN typeid SET DEFAULT nextval('"TYPES_typeid_seq"'::regclass);