Autonumbering column

Hi,

Is there anyway to have an autonumbering field?

I don't think so, but there is a way to generate the values for a key
column safely. Look at the manpage on create_sequence...james

this is a hack, but it works...

CREATE SEQUENCE key_s INCREMENT 1 START 1;
CREATE TABLE cliente (
key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
name varchar(100) UNIQUE NOT NULL,
username varchar(8) NOT NULL
);

Hi,

Is there anyway to have an autonumbering field?

I don't think so, but there is a way to generate the values for a key
column safely. Look at the manpage on create_sequence...james

Antonio Garcia Mari
Mallorca (Spain)