CREATE SEQUENCE some_sequence start 1 increment 1;
CREATE TABLE person (
id int4 default nextval('some_sequence'),
name varchar(200),
description text);
INSERT INTO person VALUES(nextval('some_sequence'),'Jeremiah','not much');
or
INSERT INTO person(name,description) VALUES('Jeremiah','not muc
Could somebody tell me how I can make efficient use of sequences? I am
familiar with Oracle's sequences and they usually work as the following
example:
INSERT INTO PERSON table(some_sequence.nextval,data,data,data);
How do they work in postgreSQL?
Roy
--
Roy Sigurd Karlsbakk - MCSE, CNE, CL
