using serial values - Mailing list pgsql-general

From Dennis Gearon
Subject using serial values
Date
Msg-id LJTOC994FCRNT1YN93WS76SN32941Z.3e4bf9fe@cal-lab
Whole thread Raw
Responses Re: using serial values  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
How do I get the values for the serial field? Do they automatically insert themselves with a
default if I do not use that field in the INSERT statement?

Example:

create table EntityTypes(
    entity_type_id serial NOT NULL CONSTRAINT PK_EntityTypes1 PRIMARY KEY,
      entity_type    varchar(16) NOT NULL,
    CONSTRAINT UC_EntityTypes_Entity_Type1 UNIQUE(entity_type)
);


INSERT INTO EntityTypes( entity_type ) VALUES 'Big Smile, Good Dresser, Easy to Get Along With';

Will the above statement causes a row to be inserted with the value for 'entity_type_id' to be
automatically 1 or 0?




pgsql-general by date:

Previous
From: Brandon Craig Rhodes
Date:
Subject: Re: arrays and pl/pgsql?
Next
From: Emmanuel Charpentier
Date:
Subject: Re: Restore from 7.3 to 7.2