create table session_vars ( session_var_id integer not null default nexval ('session_var_id_seq') primary key, session_id varchar(180) not null, session_var varchar(180) not null, -- or whatever size makes sense session_value varchar(180) not null -- again... what makes sense );