>
> when i write the following query i get the error :ERROR:
> relation
> "accounts_id_seq" does not exist
> SET search_path = test_survey;
> insert into accounts values
> (nextval('accounts_ID_seq'),'test(at)test(dot)com','ab4ef51934f2d3f02f1a','11/19/2007
> 15:46:09');
>
> why ?
>
It's lowercasing the relation name, note "accounts_id_seq" not "accounts_ID_seq". Try double quoting it.