Using Sequence.Nextval in PostgreSQL

Last Reply 9 months ago By kalpesh

Posted 9 months ago

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'