Since we gave the serial data type in the id column in the above table, a sequence named \u201cseqtable1_id_seq\u201d was created.<\/p>\n
You can view the sequences to view the sequence.<\/p>\n
We add data to our first table and see if sequence will be used.<\/p>\n
insert into seqtable1(name) values ('faruk')\r\n\r\ninsert into seqtable1(name) values ('erdem')<\/pre>\nWe have added our data, now we are checking the data in the table.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/img_63fe2017989c3.png\")
<\/p>\n
We create our second table named Seqtable2 and while creating it, we give the nextval parameter to the id part and our sequencer consisting of the name seqtable1_id_seq.<\/p>\n
create table seqtable2(id int not null default nextval('seqtable1_id_seq'),name char(100))\r\n<\/pre>\nWe add the data.<\/p>\n
insert into seqtable2(name) values ('utku')\r\n\r\ninsert into seqtable2(name) values ('erdem')<\/pre>\nIn the Seqtable1 table, we expect the last data to be one more than the value in the id column.<\/p>\n
Let’s see if the id column starts with 3 by pulling the select from the seqtable2 table.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/img_63fe22b97a2ef.png\")
<\/p>\n
If you want to use the next value with the nextval parameter in the insert sentence, you can use the command below.<\/p>\n
Syntax:\r\n\r\ninsert into tablename(column1,column2) values (nextval('sequence name'),column2data)<\/pre>\nExample :<\/p>\n
insert into seqtable2 values (nextval('seqtable1_id_seq'),'ERDEM')\r\n<\/pre>\n<\/div>\n