Using Sequence.Nextval in PostgreSQL

nandish
 
on Oct 17, 2017 12:32 AM
5349 Views

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'

Download FREE API for Word, Excel and PDF in ASP.Net: Download