Re: How to insert with a serial

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