Sequence:
Code: Select all
dbadmin=> create sequence my_seq;
CREATE SEQUENCE
dbadmin=> create table test (t int not null default my_seq.nextval, t1 varchar(10));
CREATE TABLE
dbadmin=> drop table test;
dbadmin=> insert into test (t1) values ('test1');
OUTPUT
--------
1
(1 row)
dbadmin=> insert into test (t1) values ('test2');
OUTPUT
--------
1
(1 row)
dbadmin=> select * from test;
t | t1
---+-------
2 | test2
1 | test1
(2 rows)
Code: Select all
dbadmin=> drop table test;
DROP TABLE
dbadmin=> create table test (t identity, t1 varchar(10));
CREATE TABLE
dbadmin=> insert into test (t1) values ('test1');
OUTPUT
--------
1
(1 row)
dbadmin=> insert into test (t1) values ('test2');
OUTPUT
--------
1
(1 row)
dbadmin=> select * from test;
t | t1
---+-------
2 | test2
1 | test1
(2 rows)
Thanks for your input