In <elwood.1003670142@news.agouros.de> elwood@agouros.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@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres