Using Sequence.Nextval in PostgreSQL

Last Reply on Oct 17, 2017 01:47 AM By kalpesh

Posted on Oct 17, 2017 12:32 AM

hi,

im new to postgreSQL,

how to write insert query with sequence.nextval,

i wrote query like below,

sql=insert into abc(id,name) value  (nextval('sequencename'),'"+txt.text+"');

but, getting an error like 'Relation doesn't exist'

You are viewing reply posted by: kalpesh on Oct 17, 2017 01:47 AM.