Re: How to insert with a serial

HI Konstantin

Use insert into table (type) values ('typedesc');
The database will create a sequence number to put in id

Flávio Brito
Rio de Janeiro
Brasil

Em Dom 21 Out 2001 11:16, Konstantinos Agouros escreveu:
> Hi,
>
> I have a table defined like this:
>
> Attribute | Type | Modifier
> -------------+-----------------------+-------------------------------------
>----- name | character varying(40) |
> type | integer |
> id | integer | not null default
> nextval('serial'::text) ownerteamid | integer |
> Index: devices_pkey
>
> How do I insert into it so that id is automatically incremented?
>
> Konstantin