> if i double-quote it, postgre tells me that the column accounts_id_seq does
> not exist.
You almost got it. You need to doublequote to tell nextval with
capitalization correctly, then single quote that so the query planner
doesn't say "oh look! An identifier!
create sequence "Abc";
ERROR: relation "abc" does not exist