main=# begin work;
BEGIN
main=# create table test_seq (id serial, name varchar);
NOTICE:  CREATE TABLE will create implicit sequence "test_seq_id_seq" for serial column "test_seq.id"
CREATE TABLE
main=# insert into test_seq(name) values('test');
INSERT  0   1 
main=# select last_value from "test_seq_id_seq";
 last_value
------------
           1 
( 1  row)

main=# insert into test_seq(name) values('test');
INSERT  0   1 
main=# select last_value from "test_seq_id_seq";
 last_value
------------
           2 
( 1  row)

main=# select * from test_seq where id =  1 ;
 id | name
----+------
   1  | test
( 1  row)

main=# select * from test_seq where id =  2 ;
 id | name
----+------
   2  | test
( 1  row)

main=# select count(*) from test_seq where id =  2 ;
 count
-------
      1 
( 1  row)

main=# select count(*) from test_seq where id =  1 ;
 count
-------
      1 
( 1  row)

main=# rollback;
ROLLBACK