Re: How to insert with a serial

In <elwood(dot)1003670142(at)news(dot)agouros(dot)de> elwood(at)agouros(dot)de (Konstantinos Agouros) writes:

>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?
Ok I created it with 7.0 after using type serial everything works fine \:)

Thanks for all the help,

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres